FormulaCraft

How to use XLOOKUP with multiple criteria in Excel and Google Sheets

Topic:XLOOKUP
Excel & Google Sheets
=XLOOKUP(A2&B2,$C$2:$C$5&$D$2:$D$5,$E$2:$E$5,"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

Step by step

  1. 1Decide which columns form your combined key (e.g. Region in A and Product in B).
  2. 2In the XLOOKUP, concatenate the lookup values: A2&B2, and concatenate the corresponding table columns: $C$2:$C$100&$D$2:$D$100.
  3. 3Enter the full formula: =XLOOKUP(A2&B2,$C$2:$C$100&$D$2:$D$100,$E$2:$E$100,"Not found") — in Excel confirm as a normal formula; Google Sheets handles it the same way.

Tips

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

Frequently asked

What is the equivalent for older Excel without XLOOKUP?

Use an array-confirmed INDEX/MATCH: =INDEX($E$2:$E$100,MATCH(A2&B2,$C$2:$C$100&$D$2:$D$100,0)) confirmed with Ctrl+Shift+Enter in Excel 2019 and earlier.

More on XLOOKUP

See all →
Reference

XLOOKUP

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

Error fix

Fix #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.

Error fix

Fix #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.

Formulas used

XLOOKUPINDEXMATCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: