Try

=LOOKUP(2,1/(Sheet2!F:F0),Sheet2!F:F)

Assumes the column is F in the other sheet "sheet2", change as necessary

--

_______________________
Naz,
London


"Mark Dvorkin" wrote:

Hello all,

I can get the last value in column F by using
LOOKUP(9.99999999999999E+307,F:F) on the same sheet
but have no success in geting this value from another sheet.

Thanks in advance for your help,
/mark