Show cell number or text by referencing several cells and select the highest of all(more than 3 items)

[scizor]

Hi all,
This is my first time asking question online for excel(mostly just google and have the answer)
but i struggle to think of a good way to ask this question on google.

Basically I am making a cell at E2(shown below) to show subject 1 OR A2


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]subject 1[/TD]
[TD]subject 2[/TD]
[TD]subject 3[/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]=max(A1:C1)[/TD]
[TD]??[/TD]
[/TR]
</tbody>[/TABLE]


I struggle to use if function with more than 2 cases, hopefully someone can assist me.

Thank you in advance

 

[scizor]

Sorry I haven't explain the cell's function in detail.
But I am hoping the cell itself could reference A2:C2 and select the highest number of them(which is 10) and show the above cell's text(which is Subject 1) OR show the cell it is referring to(which is A2)

A mistake was made on cell D2, should be =max(A2:C2)

 

[Marcelo Branco]

Try

E2
=INDEX(A$1:C$1,MATCH(D2,A2:C2,0))

M.