find the first cell in a row that is >=0

[MartinL]

I am trying to find the cell in a row that is >= 0%

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sep[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[/TR]
[TR]
[TD]-0.3%[/TD]
[TD]-0.2%[/TD]
[TD]-0.1%[/TD]
[TD]0.1[/TD]
[TD]0.2[/TD]
[TD]0.3[/TD]
[TD]0.4[/TD]
[TD]0.2[/TD]
[TD]0.5[/TD]
[TD]0.1[/TD]
[TD]0.15[/TD]
[TD]0.1[/TD]
[/TR]
</tbody>[/TABLE]

In the table above i need to return Apr as the first month where the percentage is >= 0

 

[steve the fish]

Try:

=INDEX(A1:L1,MATCH(TRUE,INDEX(A2:L2>0,0),0))

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2	-0.30%	-0.20%	-0.10%	0.1	0.2	0.3	0.4	0.2	0.5	0.1	0.15	0.1	Apr
Raw Data

Cell Formulas
Range	Formula
M2	=INDEX(A1:L1,MATCH(TRUE,INDEX(A2:L2>0,0),0))

 

[MartinL]

=INDEX(A1:L1,MATCH(TRUE,INDEX(A2:L2>0,0),0))

Hi steve the fish/Fluff

I did this and it works...
as expected it opened a can of worms but it works exactly as I needed many thanks

the can of worms is an issue when if there are no values >0
So I just need to get something like IFERROR(INDEX(A1:L1,MATCH(TRUE,INDEX(A2:L2>0,0),0)),"Not Found")
Which will return some text if there are no values >0

 

[Fluff]

What happens when you try that formula?