Excel formula builder
XLOOKUP Formula Builder
Generate an XLOOKUP formula for exact match, approximate match, wildcard match, or a two-condition lookup pattern.
Builder inputs
Use single-criterion mode for a normal lookup, or multiple-criteria mode to match two columns at once.
=XLOOKUP(A2, Products!A2:A100, Products!D2:D100, "Not found", 0)=XLOOKUP(A2, Products!A2:A100, Products!D2:D100, "Not found", 0)Google Sheets supports XLOOKUP, but older Excel versions may require INDEX MATCH or VLOOKUP instead.How this formula works
- XLOOKUP searches the lookup array for the lookup value and returns the aligned value from the return array.
- Multiple-criteria mode searches for 1 across multiplied TRUE/FALSE criteria arrays.
- The optional not-found argument prevents raw #N/A errors in dashboards and reports.
- Match mode controls exact, approximate, and wildcard behavior.
Sample data
| SKU | Item | Category | Price |
|---|---|---|---|
| A-100 | Keyboard | Hardware | 49 |
| A-101 | Mouse | Hardware | 25 |
| B-200 | Desk Mat | Office | 18 |
| B-201 | Notebook | Office | 7 |
Common mistakes
- The lookup array and return array must have compatible dimensions.
- Wildcard match mode only matters when the lookup value contains wildcard characters.
- Use exact match for SKUs, IDs, names, and most business lookup keys.
Related formulas
FAQ
Are these formulas generated with AI?
No. The builder uses deterministic TypeScript functions in the browser and does not call any AI API.
Do I need to upload my spreadsheet?
No. Enter ranges and criteria manually. The site does not upload, store, or process spreadsheet files.
Can I copy the generated formula?
Yes. Each output includes a copy button so you can paste the formula into Excel or Google Sheets.