Try the below..to retieve the last number

=LOOKUP(10^10,Sheet2!A:A)

--
Jacob (MVP - Excel)


"Keith" wrote:

I have a column listing numbers in worksheet B. I'm looking for a formula
to place in worksheet A that will list the bottom number listed in that
worksheet B column.

Any help would be much appreciated.