Last column entry lookup.

B

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
 
Top