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,

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

<tbody>
</tbody>

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.