Find cell with first zero value in a row and show value in another row in same column

[crafunding]

I have spreadsheet where I want to identify the Year in which a row of numbers first becomes zero. Example, say row #20 has numbers that decline in value and eventually become zero. That happens in column Z. Line #10 has a year associated with each column. In cell A2 (for example), I want to show the Year associated with column Z that appears in cell Z10. Any ideas? Thanks.

[Tony Valko]

Try something like this...

Data Range

	A	B	C	D	E	F	G	H	I
1	2000	2001	2002	2003	2004	2005	2006	2007	2008
2	78	66	55	50	22	17	0	0	-19
3
4	2006

This formula entered in A4:

=INDEX(A1:I1,MATCH(0,A2:I2,0))