I think you mean something like this:

=LOOKUP(1000000,A:A)

It will return the number that is in the last cell in column A. The value 1000000 is just a large number - it must be larger than any number which is likely to exist in column A.

Hope this helps.

Pete