How to LOOKUP the last value in a column on another worksheet?

[Mark Dvorkin]

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

 

[Naz]

Try

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

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

 

[Peo Sjoblom]

It's no difference whether it is referring to another sheet,
are you using numbers only?

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Mark Dvorkin]

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!!!

 

[Domenic]

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

http://www.mrexcel.com/board2/viewtopic.php?t=103168&postdays=0&postorder
=asc&start=0

 

[Mark Dvorkin]

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