Hi,
In the attached workbook I have sample data in A:E.
In cell K6 I have an INDEX MATCH formula that extracts the value that corresponds with the conditions in H3:H6.
Is it possible to use XLOOKUP() rather than INDEX MATCH to perform such a two-way lookup with multiple conditions?
Thanks!
Try this:
=XLOOKUP($I$5&$I$6,$C$1:$E$1&$C$2:$E$2,XLOOKUP($I$3&$I$4,$A$3:$A$6&$B$3:$B$6,$C$3:$E$6,,0))
https://exceljet.net/formula/xlookup...ay-exact-match
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I'd tend to use Filter rather than xlookupFormula:
Please Login or Register to view this content.
Thanks very much, Ali!
I tried to add to your reputation but can't as I've just done so in my other post that you kindly answered.
Don't worry!
I'd agree with Fluff, by the way, although doing the XLOOKUP was a good academic exercise.
Please mark as solved.
Thank you both very much!
Am I correct to understand that you're suggesting that FILTER() would be preferable to functions like XLOOKUP (and so VLOOKUP) and INDEX MATCH for performing lookups?
In this case, yes, but not necessarily always!
Glad to help & thanks for the feedback.
Normally I would use Xlookup, but in cases like this I just find Filter is easier to understand.
Thanks again!
Please mark as solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks