CALC: asking CALC to find the bottom most number in a column

I have a formula in CALC that needs the bottom-most number in a column for its result. How do I make CALC find that number?

Assuming your values / numbers are in the range A1:A99

=LOOKUP(2;1/ISNUMBER(A1:A99);A1:A99)

Brilliant! Works perfectly. Thanks very much,