Free utility

Lookup formula generator

Type the condition in simple words, choose Excel or Google Sheets, and generate VLOOKUP, HLOOKUP, XLOOKUP, INDEX MATCH or FILTER formulas instantly.

Rule-based in Delivery 5: fast, private and not dependent on AI. AI/Ollama formula suggestions can be added later.

Describe your lookup

=XLOOKUP(A2,Sheet2!A:A,Sheet2!D:D,"Not found")

This formula searches A2 in Sheet2 column A and returns the matching value from Sheet2 column D. If no match is found, it returns “Not found”.

Use XLOOKUP for modern Excel when you can select separate lookup and return ranges.

Examples

=XLOOKUP(A2,Employees!A:A,Employees!D:D,"No email")

Find employee email using employee code.

=IFERROR(VLOOKUP(B2,Vendor!A:E,5,FALSE),"Missing")

Check whether a serial number exists in vendor billing.

=IFERROR(FILTER(Sheet2!D:D,Sheet2!A:A=A2),"Not found")

Return matching rows in Google Sheets.

Use this generator when you need a quick formula. Use ReconNimble reconciliation when you need full matched, missing, duplicate and conflict reports.

Upload two files, map keys, run comparison and export an action sheet.