XLOOKUP

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

4 pages · 1 reference, 1 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.

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.