Resolved: x lookup question vs nested functions.
Hi, is Xlookup a sufficiant subtitude for INDEX $ MATCH? And what about Xlookuo vs INDEX & MATCH, MATCH..? Thanks..!
1 answers ( 1 marked as helpful)
Great to hear from you!
Yes, XLOOKUP is a sufficient substitute of INDEX & MATCH. I don't think it can substitute INDEX, MATCH, MATCH though.
Submit an answer
Can you combine Match and Indirect (for selecting the lookup array) in the same function?