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...
Your original function returns the intended result. My screenshot shows the translation of your original function for german Excel. If either of the tables isn't formatted as a dynamic table it doesn't work. Your screenshots show that you are working with dynamic tables. The left table in my screenshot and sample file must be named "GameStats". I assume your referenced dynamic table is named "GameStats".
Then perhaps you've activated "Show formulas".
I am wondering if it is because the formula is addressing two different worksheets. I'm not sure thank you though for your reply. I am also trying to figure out how to upload a workbook for someone to see if they can find the solution.
Thank you again. Take care.