Help with Looking up the value

[moxman]

Hi,

I am familiar with the vlookup function however, I wanted to do a table where I can identify the best statistic of a person based on the highest number and indicate which stat is that on the next cell. Confusing? Please see the attached picture and file.

sample.pngSample Data.xlsx

Attachment 329852

as you can see on the photo, Tom's best stat is scoring points. I obtained the value by using the formula =MAX(F6:H6). The problem is, how to i automate the value of the cell next to it J6 or the ?? cell. It should show "Points".
Another question is, what if there are two identical numbers? Like what happened to Ben, how can make show both or only one?

Thank you, your help is greatly appreciated

[berlan]

In J6, try:

Please Login or Register  to view this content.

Cheers,
berlan

[FDibbins]

No need for offset, this will do it for you...

=INDEX($F$5:$H$5,MATCH(I6,F6:H6,0))

It will ID the 1st match it finds

(OFFSET() is a volatile function, and, if used in enough quantities, will start to slow your file down)

[FDibbins]

Thanks for the feedback, berlan