Replace Header based on Max Value

[prasud]

Hi

I have the following problem. First Row is the Header[TABLE="width: 500"]
<tbody>[TR]
[TD]Name of Student[/TD]
[TD]Visual[/TD]
[TD]Auditory[/TD]
[TD]Kinesthetic[/TD]
[TD]Major Strand[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]Student 1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]Kinesthetic[/TD]
[/TR]
[TR]
[TD]Student 2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]Auditory[/TD]
[/TR]
[TR]
[TD]Student 3[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]Visual[/TD]
[/TR]
</tbody>[/TABLE]

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.