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...
I seem to have gotten closer with this as the function:
=XLOOKUP(1,(CompiledGS[@[High Score]],GameStats[Score])*(CompiledGS[@[Board Game]],GameStats[Board Game])*(GameStats[Board / Scenario],CompiledGS[@[Board / Scenario]]),GameStats[@Player],,0,1)
It now returns #VALUE!
I have at least got it to return something in the cell. Now to see if I can get it to do what I want.
Hoping someone has an answer for this one for me.
Take care and have a nice day.
That formula does not work in the table only in cells outside.