Get column header based on value in a table

[djgenesis13]

I want to search (with a formula) for a value and get the header of the column it exists (preferably without a "helper" column)

I have this table...
A	B	C	D	E	F	G	H	I
1		January	February	March	April	May	June	July
2	1	X	X	X	X	A	X	X
3	2	X	X	B	X	X	X	X
4	3	X	X	X	X	X	X	X
5	4	X	X	X	X	X	X	C
6	5	X	X	X	X	X	X	X
7	6	X	X	X	D	X	X	X
8	7	X	X	X	X	X	E	X
I want to get these results
10	A	May
11	B	March
12	C	July
13	D	April
14	E	June

<colgroup><col span="9"></colgroup><tbody>
</tbody>

Could anyone help?

 

[Special-K99]

With January in C2
put the values A to E in B10:B14 as your layout suggests

in C10
=INDEX(C$2:I$2,MAX(IF(C$3:I$9=B11,COLUMN(C$1:I$1)-COLUMN(C$1)+1)))
Array formula, use Ctrl-Shift-Enter
and copy down the column