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

	A	B	C	D	E
1	subject 1	subject 2	subject 3	X	X
2	10	5	1	=max(A1:C1)	??

<tbody>
</tbody>

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.