Returning text based on max value in a table

[BWellman]

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!

[Richard Buttrey]

Hi,

For largest use

Please Login or Register  to view this content.

for 2nd & 3rd largest change the 1 inside the Large statement.