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!
Bookmarks