Hey all

I am looking to return text based on the maximum value in a table.

Dog 2
Cat 10
Horse 4
Fish 27
Lion 1

Let's call the column with the animals over it "A" and the one with the numbers "B", and the rows are 1-5 to make explanations easier

I am looking to have a formula return the name of the animal with the highest three numbers (fish, cat, horse), but don't need the numbers. I am pretty confident this would be an index match formula, but I'm not too familiar with those functions.

Hopefully someone can help,

Thanks!