XLOOKUP with Multiple Criteria in Excel

Method 1: multiply the conditions

=XLOOKUP(1,(A2:A100=F2)*(B2:B100=G2),C2:C100)

Each test gives TRUE/FALSE for every row. Multiplying them gives 1 only where both are true. XLOOKUP then finds the first 1.

Three conditions

=XLOOKUP(1,(A2:A100=F2)*(B2:B100=G2)*(C2:C100=H2),D2:D100)

With a “not found” message

=XLOOKUP(1,(A2:A100=F2)*(B2:B100=G2),C2:C100,"No match")

Method 2: join the keys

=XLOOKUP(F2&"|"&G2,A2:A100&"|"&B2:B100,C2:C100)

The | stops false matches like “AB”+”C” vs “A”+”BC”.

Conditions with > or <

=XLOOKUP(1,(A2:A100=F2)*(C2:C100>500),C2:C100)

Either condition (OR)

=XLOOKUP(1,--((A2:A100=F2)+(B2:B100=G2)>0),C2:C100)

All matches, not just the first

Use FILTER: return multiple values.

No XLOOKUP?

=INDEX(C2:C100,MATCH(1,(A2:A100=F2)*(B2:B100=G2),0))

Press Ctrl+Shift+Enter in Excel 2019 and older. See INDEX MATCH.

Basics: XLOOKUP