Thanks! It works great. But can you explain to me what is happening.
More specifically I don't understand 1/(A1:A65535<"").

Cat


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Cat

From Bob Phillips.......=LOOKUP(2,1/(A1:A65535<""),A1:A65535)


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 16:46:33 -0500, "Cat Chowdy" <catchowdyathotmaildotcom
wrote:

I am trying to get the last value in a column. I don't know what row that
will be in - as that can vary. How can I address the last filled in cell
in
a specific column?

Thanks,
Cat