Formula help please

[Formula help]

A B C
80 100 700
70 200
65 300
40 400
24 500
19 600
0 700
0 800
0 900

I have two columns. Column A will have a series of descending numbers that
can start with any value and will end with 0. The number of 0’s can vary. The
values of the numbers in Column will change each time I run a program, but
will end with one or more 0's. Column B will have another series of numbers
but these numbers will not change each time the program is run.

I would like to show in cell C1, the number in Column B that is adjacent to
the first time a 0 appears in Column A. In the example shown, 700 is the
number in Column B that corresponds to the first time a 0 appears in Column A.

I need the formula for cell C1.

Thanks for the help,

Bill

 

[Jacob Skaria]

Try

=VLOOKUP(0,A1:B10,2,0)

If this post helps click Yes

 

[DILipandey]

Following two formula, will deliver the expected results,
=OFFSET($A$1,MATCH(0,$A:$A,0)-1,1)

=INDEX($A:$B,MATCH(0,$A:$A,0),2)

--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India