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?


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]H1[/TD]
[TD]H2[/TD]
[TD]H3[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]y[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]H2[/TD]
[/TR]
[TR]
[TD]z[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]H1[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.