look up functions
 

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??

look up functions
 

If you mean the very last row in the sheet, you can use

=INDEX([Book2]Sheet1!$C$1:$C$19,MATCH(1,--(NOT(ISBLANK([Book2]Sheet1!$C$1:$C$19))),1))

This is an array formula, meaning you commit it by simultaneously pressing
Ctrl-Shift-Enter. Adjust it to reflect your workbook and worksheet names and
ranges

Note - it assumes there are no blank rows.

"Misti" wrote:

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??

look up functions
 

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??