What I meant to say was enter the row within the last column not both the
last column and last row.

"Peo Sjoblom" wrote:

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

for the last row in A1:A20000

adapt to fit


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

last column in row 2


--


Regards,


Peo Sjoblom






"Loadmaster" wrote in message
...
That formula worked great, however I have one more question WRT the same
spreadsheet. How do I retrieve the last entry from the last row and
column?