Find Largest and Return Column Name

[Tom321]

I am comparing 3 columns and trying to find the maximum value of the columns.
But instead of just displaying the maximum value I would like it to show
which column the value is from.

OBS_ID CLASS1 CLASS2 CLASS3
A 2 5 10
B 12 10 4
C 5 1 15
D 2 6 12
E 1 23 9


So in this case, when the formula is run it will return "CLASS3" for Row A
and "CLASS1" for Row B and so on..

Thanks for you help

 

[kraljb]

Assuming that your Column Titles are in Row1 and that Data begins Row2
=INDEX(A11,0,MATCH(MAX(A22),A22,0)

 

[Tom321]

Thanks, that worked perfectly