I am looking to find the highest selling drink within each category in cells C6:C16. I am able to find the highest value in each category with a MAXIFS function, but I want to further pull the corresponding beverage name (for example, Stella Artois for the Beer Category). How do I find that value? Is it a VLOOKUP?
Thanks in advance!
Caveat:
Note that this needs autofill / dragging down to C16 to get all the needed values.