=LOOKUP(9.99999999999999E+307,F:F) willl fetch the last numeric value in F

=LOOKUP(REPT("z",255),B2:B10000) If column B data is of 'text' type, use this

=LOOKUP(2,1/(A1:A65535<""),A1:A65535) will fetch last value, number or text


Gord Dibben MS Excel MVP


On Mon, 27 Nov 2006 00:42:05 +0000, anthonyberet wrote:

I have a worksheet which is updated regularly with a new line, working
from the top down. I would like to find worksheet function which can
return the value in the bottom cell of a column which is not blank, so
that this value can be used in another worksheet.

ie I want to be able to return the most recent value in a column at any
time.

I had hoped there would be a ready-made function for this, but it
appears not.

Any ideas?