Lookup value meeting criteria, return column heading

[Askew]

I am trying to search for a value >2 in a row, and return the column header of the cell which meets that criteria. Currently I have INDEX/MATCH/MAX to return the header, but I am having trouble making it conditional (>2). Below I have illustrated the desired result. What formula can I put in column E that will return this?

	H1	H2	H3	Result
x	1	0	1	-
y	0	2	1	H2
z	3	0	0	H1

<tbody>
</tbody>

 

[AhoyNC]

If you have Excel ver. 2010 or later try:
This formula assumes as in your example that only one number in the row can be above 2. If there could be multiple values in the row above 2 we would need to make some changes.
Copy formula down as needed.

Excel Workbook
	A	B	C	D	E
1		H1	H2	H3	Result
2	x	1	0	1
3	y	0	2	1
4	z	3	0	0	H1
Sheet

 

[glfiedler]

Askew, try this:

=IF(B2>=2,B$1,IF(C2>=2,C$1,IF(D2>=2,D$1,"-")))

In your question you stated you were looking for values >2 yet your example gives a result for =2 also.
If your just want >2 then delete the = sign from the above equation.