Here are 2 options:

For values in A1:A10

C1: =INDEX(A1:A10,SUMPRODUCT(MAX((A1:A100)*ROW(A1:A10 ))),1)

Or...this array formula*:
C1: =INDEX(A1:A10,MAX((A1:A100)*ROW(A1:A10)),1)

Note: For array formulas, hold down [Ctrl] and [Shift] when you press [Enter].

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"FishHead" wrote:

I would like to display the cell which holds the "last" positive number in a
column vector. (in other words...if the vector is a1:a3 with a1=2, a2=1,
a3=0, then I would like to display the value in a2 (1).) It seems like the
lookup function should work for this but I'm not sure how to specify "last
positive number" in the function? Thanks in advance for any ideas.