Lookup Formula Generator
Type a condition and generate VLOOKUP, HLOOKUP, XLOOKUP, INDEX MATCH or Google Sheets formulas.
Open NewReconNimble tools help teams compare Excel, CSV and TSV files, generate lookup formulas, find missing records, detect duplicates, audit licenses and reconcile asset/vendor data without writing formulas manually.
Type a condition and generate VLOOKUP, HLOOKUP, XLOOKUP, INDEX MATCH or Google Sheets formulas.
Open NewCompare two Excel workbooks or selected sheets by a chosen key.
Open LiveFind rows present in one dataset but missing in another.
Open LiveGroup duplicate employees, serials, emails, invoices or asset tags.
Open LiveCompare clean or messy CSV exports from HR, admin and vendor tools.
Open LiveGet matched results without writing formulas manually.
Open LiveMatch similar names, initials, email usernames and spacing variations.
Open LiveAudit active and inactive employee mailboxes.
Open TemplateCompare asset masters with billing, dispatch and received sheets.
Open TemplateUse the template library for common HR, IT asset, vendor billing and email license reconciliation jobs.
Open templatesDownload small CSV pairs and verify the workflow before uploading live data.
Download sample filesAdSense publisher is configured. Add display ad units after approval. Paid Pro and Team users do not see ads.