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...
So far nothing has worked for this xlookup. I tested the cell with other formulas such as countif, or maxifs and they work fine.
Any xlookup formula I put in there though ends up with text spread across the cells. The cell is formatted as general which the cells in Game Stats are formatted as well because I know one error that can occur is if the cells are not formatted the same. I just have not been able to figure out what will work here the Let formulas don't work I am at a loss as to why this ends up as just text streaming across cells and doesn't return anything when others can make it work. Any further help with this problem will be appreciated.