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:

A	B	C	D	E	Minimum	Header Value
2	3	4	5	6	2	A
33	32	30	44	44	30	C
12	11	10	9	8	8	E
1	2	3	4	5	1	A

<tbody>
</tbody>

 

[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