Extract upper value if the line below has 0

[motilulla]

Hello,</SPAN></SPAN>

I need a Formula or VBA, not a Function, which can extract upper value if the line below has 0. Result in column L</SPAN></SPAN>

Here is an example....</SPAN></SPAN>

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1
2		n1	n2	n3	n4	n5	n6	n7	n8	n9		Result
3		10	0	23	1	15	2	7	8	5		n2
4		11	1	24	2	0	3	8	9	6		15
5		12	2	25	0	1	4	9	10	7		2
6		0	3	26	1	2	5	10	11	8		12
7		2	0	4	8	1	5	7	12	14		3
8		3	0	5	9	2	6	8	13	15		0
Sheet2

Thank you all</SPAN></SPAN>

Excel 2000</SPAN></SPAN>
Regards,</SPAN></SPAN>
Moti</SPAN></SPAN>

 

[Fluff]

In L3 & copied down
=INDEX(B2:J2,MATCH(0,B3:J3,0))

 

[motilulla]

In L3 & copied down
=INDEX(B2:J2,MATCH(0,B3:J3,0))

Fluff, it worked perfect!! Thank you so much for your help with in the 4 min time only it is incredible</SPAN></SPAN>

Have a nice weekend</SPAN></SPAN>

Kind Regards</SPAN></SPAN>
Moti </SPAN></SPAN>

 

[Fluff]

Glad to help & thanks for the feedback.

Have a good weekend yourself.