Naz,

if you could explain the syntax of your example ...
2,1/ what it means?

Nevertheless your example answered my question.

=LOOKUP(9.99999999999999E+307,Sheet2!F:F)

calling the function from a cell on sheet1
gets the last value in the F column of sheet2

Thanks!!!

Naz wrote:

Try

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

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