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!
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!