lookup function
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.
|