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...
For me it works if you use same-row references inside the table you are writing the formula into:
=XLOOKUP(1, ([@[High Score]]=GameStats[Score])*(GameStats[Board Game]=[@[Board Game]])*(GameStats[Board / Scenario]=[@[Board / Scenario]]),GameStats[Player],,0,1)