Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
XLOOKUP
XLOOKUP searches a lookup array and returns the corresponding item from a return array. It works left or right, defaults to exact match, and lets you supply a fallback when nothing is found.
Topic:XLOOKUPExcel
=XLOOKUP(D2, A:A, B:B, "Not found")Google Sheets
=XLOOKUP(D2, A:A, B:B, "Not found")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1D2 is the lookup value.
- 2A:A is the column to search.
- 3B:B is the column to return from.
- 4"Not found" is returned when there is no match.
More on XLOOKUP
See all →How-to
How to use XLOOKUP with multiple criteria
Concatenate criteria columns in XLOOKUP's lookup array to match on multiple conditions at once, returning results only when all criteria align.
Error fixFix #N/A
Fix #N/A errors in XLOOKUP in Excel and Google Sheets — lookup value not found, data-type mismatch, incorrect array size, and match mode issues.
How-toHow to return multiple columns with XLOOKUP
Learn how to use XLOOKUP to fetch data from multiple columns efficiently in both Excel and Google Sheets.
Error fixFix #SPILL!
Fix #SPILL! errors from XLOOKUP in Excel — spill range blocked by non-empty cells, merged cells, or returning an array into a table column.
How-toHow to use XLOOKUP with wildcards
Learn how to use XLOOKUP with wildcards to perform flexible lookups in Excel and Google Sheets.