Last column entry lookup.

[Bg]

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

 

[Roger Govier]

Hi

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