Home > database >  Finding highest selling item within a category
Finding highest selling item within a category

Time:11-13

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!

enter image description here

Caveat:

Note that this needs autofill / dragging down to C16 to get all the needed values.

  • Related