If your data in Column A has no gaps in it, this formula can be used...

=OFFSET(A1,COUNTA(A:A)-2,0)

If there are (or can be) gaps in your data, then this formula can be used...

=OFFSET(A1,MATCH(LOOKUP(2,1/(A1:A65535<""),A:A),A:A,0)-2,0)

Rick


"Luke" wrote in message
...
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