Forum Discussion
Solved
XLOOKUP Multiple Lookup Values?
I have a project where I have been using XLOOKUP to pull information from one sheet into another, but my problem is the following: To see if there is a match, I have to check three different lookup v...
I found the solution! I needed to use an IFNA function to search for the first two variables, then nest that whole formula within another IFNA function to get the third. This video helped me: https://www.youtube.com/watch?v=AXo9BPqbvxo&t=195s
XLOOKUP may not be the best fit for the situation. If there's a need to return multiple values then FILTER may be a better option or even an aggregation function such as GROUPBY. Do you happen to have a sample workbook to share?
It's confidential info so unfortunately I can't share. But I will try what you suggested, thanks!