=LOOKUP(2,1/(A1:A1000<""),A1:A1000)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Sanj" wrote in message
...
I need a formula where everytime I update with a new month's data, that
formula will pickup that number
For e.g. If I populate 145 right underneath 89, that formula will pickup
145
45
56
89

Sanj