Excel seriously needs a lastrow() function... these tricks look awful.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Aladin Akyurek" wrote in message
...
For the column which houses text values like 2005-03, invoke:

=LOOKUP(REPT("z",255),Hours!X:X)

Adjust for the column to suit.

Jane Doe wrote:
"Aladin Akyurek" wrote in message
...

=LOOKUP(9.99999999999999E+307,Hours!A:A)

if column A houses numeric data like dates, time values, or just numbers.
It will return the last numeric value from column A on sheet Hours.


Thanks but one column doesn't work

The cell contents are 2005-03 in Hours but in the Invoice it says #N/A

This column has my invoice number like 2005-01, 2005-02, 2005-03 etc etc