Another way:

=LOOKUP(2,1/(Sheet1!A1:A20<""),Sheet1!A1:A20)

Biff

"Misti" wrote in message
...
If I have a worksheet that is a series of text logs that ascend vertically
down and I want the last entered log to be displayed on another worksheet,
how do I do this??