Search data within table and return the column header

[winfs]

Hi

I am trying to search a data within a table and return the header of the corresponding column. For example,

[TABLE="width: 192"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="class: xl65, width: 64"] A[/TD]
[TD="class: xl65, width: 64"] B[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]Test1[/TD]
[TD="align: right"]Test2[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]18[/TD]
[TD="class: xl66"] B[/TD]
[/TR]
</tbody>[/TABLE]
If cell A7 = 18, then cell B7 = Test2
If cell A7 = 15, then cell B7 = Test1

can anyone help to create such formula in cell B7?

thanks,

 

[Aladin Akyurek]

Book1
	A	B	C
1	Test1	Test2
2	12	17
3	13	18
4	14	19
5	15	20
6
7	18	Test2
8
Sheet1

In B7 control+shift+enter, not just enter, and copy across:

=IFERROR(INDEX($A$1:$B$1,SMALL(IF($A$2:$B$5=$A$7,COLUMN($A$1:$B$1)-COLUMN($A$1)+1),COLUMNS($B$1:B$1))),"")

 

[winfs]

How....never think of that formula solved. Thank you very much.

 

[Aladin Akyurek]

How....never think of that formula solved. Thank you very much.

You are welcome.