Finding column header

[ankurm84]

Hello,

I have data in 5 columns having header.

Now in 6th column I have value which in minimum of that particular row.

Based on this minimum value I need to get corresponding column header in 7th column respective to each row.

Similar to table shown below:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]Minimum[/TD]
[TD]Header Value[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]32[/TD]
[TD]30[/TD]
[TD]44[/TD]
[TD]44[/TD]
[TD]30[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]11[/TD]
[TD]10[/TD]
[TD]9[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]A[/TD]
[/TR]
</tbody>[/TABLE]

 

[AlanY]

try it in G2 and copy down

=index($a$1:$e$1,match($f2,$a2:$e2,0))

 

[ankurm84]

Thanks it is working.

 

[AlanY]

you're welcome