XLOOKUP Formula Generator
XLOOKUP is the modern replacement for VLOOKUP and HLOOKUP. It can search in any direction, return multiple columns, and has built-in error handling with a default "not found" value.
Syntax
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])Try it — generate a XLOOKUP formula
Examples
Simple lookup with fallback
=XLOOKUP(A2, Products!A:A, Products!C:C, "Not found")Looks up A2 in Products column A, returns column C. Shows "Not found" if no match.
Return multiple columns
=XLOOKUP(D1, A:A, B:D)Returns values from columns B, C, and D all at once for the matched row.
Tips
- ✓XLOOKUP defaults to exact match — no need to specify FALSE like VLOOKUP.
- ✓The "if_not_found" parameter eliminates the need to wrap in IFERROR.
- ✓Available in Excel 365 and Google Sheets. Not available in older Excel versions.
Related Formulas
VLOOKUP
VLOOKUP searches for a value in the first column of a table and returns a value ...
INDEX-MATCH
INDEX-MATCH is a powerful combination that can look up values in any direction —...
FILTER
FILTER returns rows from a range that meet specified conditions. It's like AutoF...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free