fx =XLOOKUP(E1,A1:A100,C1:C100,"Not Found")ABCSKU-4821Widget A$24.99SKU-7293Gadget B$89.50SKU-1056Tool C$12.75
🔍 Lookup

XLOOKUP Formula for Lookup

Modern replacement for VLOOKUP (Excel 365). Copy-paste ready for Excel, Google Sheets, and Airtable.

=XLOOKUP(E1,A1:A100,C1:C100,"Not Found")
When you need this: When you need to look up a customer email (A1) from your contact list (A1:A100 contains emails, C1:C100 contains names).

How it works

  1. 1XLOOKUP searches for the lookup value (E1) in the lookup array (A1:A100).
  2. 2Returns the matching value from the return array (C1:C100).
  3. 3If not found, returns the default ("Not Found") instead of #N/A error.

Variations

XLOOKUP searching right to left
=XLOOKUP(E1,A1:A100,C1:C100,"Not Found",-1)
XLOOKUP with wildcard matching
=XLOOKUP("*Smith*",A1:A100,C1:C100,"Not Found",2)

Related Formulas

VLOOKUP — Look up a value in a table by matching the first columnLookupINDEX/MATCH — Flexible lookup - more powerful than VLOOKUPLookupFILTER — Return rows matching criteria (dynamic filter)LookupSORT — Sort a range dynamicallyLookup

Need a formula that's not here?

Generate custom formula →