Lookup (Index? Match?) First Instance of Condition in Column

[screech]

I have two columns:

A | B
------
1 | 24
2 | 12
3 | 5
4 | 0
5 | 23
6 | 25
7 | 0
8 | 0
9 | 18

This is probably very simple, but what would the formula be to lookup the first instance of a "0" in column B and return the value in column A at that row. Example, find the first "0" in B, result would be "4". I've tried a variety of lookup, match, and index commands, but none seem to work just as it should.

Thanks!

 

[Greg Truby]

book1
	A	B	C	D
1	A	24	0	D
2	B	12	25	F
3	C	5
4	D	0
5	E	23
6	F	25
7	G	0
8	H	0
9	I	18
Sheet1

Values to look for in C, but could be incorporated into formula in D.

Formula in D1:
=INDEX(A$1:A$9,MATCH(C1,B$1:B$9,0))

 

[screech]

Re: Lookup (Index? Match?) First Instance of Condition in Co

I could have promised that I've tried that formula before many times without success, but now I try it again and it works like a champ. Thanks for the assist, Greg.