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

[MartinL]

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

Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
-0.3%	-0.2%	-0.1%	0.1	0.2	0.3	0.4	0.2	0.5	0.1	0.15	0.1

<tbody>
</tbody>

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?