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...
It is probably something very simple does not seem to be working for me. I am frustrated because half of my replies don't show up and I'm trying to figure why that is.
I made sure the cells were the same format I tried both General and Text it doesn't matter it only shows the string for the formula. When I hover over the score it just becomes a text cursor something isn't working I wish I could get this to someone who could look at it and probably have the answer in a minute, I am hoping this reply shows up, but am not optimistic.
It hasn't mattered what formula I've used for this it is not working. I have a Countif and a Maxifs formula working in other cells, but no joy with this one.