Forum Discussion
SusanJackson
May 01, 2023Copper Contributor
Xlookup multiple match criteria
Hi - I would like to use a look up table to return an exact match based on multiple criteria (like an AND nesting in an IF function). My data does not have a single key so I need to match 3 differen...
HansVogelaar
May 01, 2023MVP
I'd use INDEX+XMATCH:
=INDEX('Lookup Table'!$D$2:$D$9, XMATCH(1, ('Lookup Table'!$A$2:$A$9=A2)*('Lookup Table'!$B$2:$B$9=B2)*('Lookup Table'!$C$2:$C$9=C2)))
SusanJackson
May 02, 2023Copper Contributor
Thank you Hans - this is very simple and works well for this first pass model