Replace Header based on Max Value

[prasud]

Hi

I have the following problem. First Row is the Header

Name of Student	Visual	Auditory	Kinesthetic	Major Strand	Name
Student 1	1	2	3	3	Kinesthetic
Student 2	3	4	2	4	Auditory
Student 3	5	3	1	5	Visual

<tbody>
</tbody>

In the above table, I will be filling all columns upto Kinestheti, and get the output of Maximum value in "Major Strand" ("=max(b2:d2)"). I want the "Name" column to automatically fill the header based on the value, as shown in the sample above.

I tried "=lookup(e2,b2:d2,b1:d1)" but it is working only if the values in the rows are in ascending order.

I would like to get a solution urgently. Please help.

Best regards
Prabhu Sukumaran

 

[vds1]

Try,

If your data is from column A to E , In F2 try, drag down

=INDEX($B$1:$D$1,MATCH(E2,B2:D2,0))

 

[prasud]

Try,

If your data is from column A to E , In F2 try, drag down

=INDEX($B$1:$D$1,MATCH(E2,B2:D2,0))

Thank you very much for your quick reply. Hats Off.