look up functions

M

Misti

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

Duke Carey

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.
 
Top