Forum Discussion
XLOOKUP not working for multiple criteria
Hi all, I am setting up a workbook for boardgames played for someone and he wants to see the high score returned for each game. I have tried xlookup in multiple ways and have had no success. Here i...
Hi NikolinoDE
I have had no luck replying to you directly so I am trying a different method. Unfortunately your solution hasn't worked here is what it looks like:
It may be because the tables are on two different worksheets in the workbook, but I can't even get the formulas to produce an error just the text from the formula.
I haven't been able to figure out how to upload a workbook because I would do that in a second figuring someone might have more luck with it then I do.
Thank you for your help.