Domenic,
Thanks for the link: I'm still chewing on it!

Domenic wrote:

Have a look at Aladin's explanation in the following link...

http://www.mrexcel.com/board2/viewto...ys=0&postorder
=asc&start=0

In article , Mark Dvorkin
wrote:



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