XLOOKUP

XLOOKUP — the modern VLOOKUP replacement. Bidirectional, exact-match by default, built-in not-found handling. Every XLOOKUP recipe and fix here.

6 pages · 1 reference, 3 how-to, 2 error fix

Reference

The modern replacement for VLOOKUP and INDEX/MATCH — look up a value and return a match in any direction.

Concatenate criteria columns in XLOOKUP's lookup array to match on multiple conditions at once, returning results only when all criteria align.

Learn how to use XLOOKUP to fetch data from multiple columns efficiently in both Excel and Google Sheets.

Learn how to use XLOOKUP with wildcards to perform flexible lookups in Excel and Google Sheets.

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.

Fix #SPILL! errors from XLOOKUP in Excel — spill range blocked by non-empty cells, merged cells, or returning an array into a table column.