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

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

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" wrote in message
...
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,

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

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

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