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