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 0s 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

Try

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

If this post helps click Yes
---------------
Jacob Skaria


"Formula help" wrote:

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 0s 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

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.)


New Delhi, India


"Formula help" wrote:

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 0s 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