look up latest entry in a series?

[sschmerl]

Dear experts:
On sheet 1 I have a series of dates in order in column 1. In column 2
is a measure which I enter as the date is reached. In column 3 is a
formula which uses the number in column 2 to calculate a number. (In
the rows where column 2 is not yet populated, the formula returns
zero.)
On sheet 2, I want to enter a formula in one cell which will return
the value in column 3 on sheet 1 which corresponds to the last row in
which a value has been entered in column 2. In other words, the
latest value that is not a zero.

Can this be done?

 

[Pete_UK]

Try this:

=LOOKUP(10^100,Sheet1!2:2)

Hope this helps.

Pete