Marcello, the formula returned a blank cell. I think because it is looking
for text and my data is numeric. However I do have blank cells in the column.
Any thoughts?
Luke

"Marcelo" wrote:

you can use

=indirect("Sheet2!A"&counta(Sheet2!a:a)-1)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Luke" escreveu:

This formula works great to find the last entry in a col.
=LOOKUP(99^99,Sheet1!A:A)
Is there a way to get the formula to show the 2nd to the last entry?

Thank you for all you do,
Luke