Forum Discussion
XLOOKUP not working for multiple criteria
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 I am working with two different worksheets in the workbook. I am trying to figure out how to upload a workbook as I think that will make everyone's job easier, but I can't seem to find that function on this site.
Thank you for your help though I know it works on a single worksheet. Take care.