Which column is the value in?

[coach.32]

Hi. I have attached a spread sheet that contains three columns of numbers.
There is only 3 rows of data. I have column headers (1-2-3.
Next to each row of data I have a formula to tell me which is the MAX value for each row.
What formula do I use to tell me what column (1, 2 or 3) the Max value is in.
Thank you for your help.

[simarui]

how bout:

Please Login or Register  to view this content.

[Jonmo1]

In E2: =MATCH(D2,A2:C2,0)

Now, this gives you the column #.

If you wanted to actually return the value in row 1 of that column
Use
=INDEX(A$1:C$1,MATCH(D2,A2:C2,0))