Last column entry lookup.
 

Trying to bring the last entry made in column F (from a checking balance
workbook) The formula works OK for the first sheet but doesn't work when I
copy it another sheet.
=LOOKUP(9.99999999999999E+307,F:F)
It will, however, return the value in cell F307.
What am I dong wrong??

Thnx
Bg

Last column entry lookup.
 

Hi

Works fine for me.
Try
=LOOKUP(9.99999999999999E+307,Sheet2!F:F)

--
Regards

Roger Govier


"Bg" wrote in message
...
Trying to bring the last entry made in column F (from a checking
balance workbook) The formula works OK for the first sheet but doesn't
work when I copy it another sheet.
=LOOKUP(9.99999999999999E+307,F:F)
It will, however, return the value in cell F307.
What am I dong wrong??

Thnx
Bg