have cell in sheet 1 look up last row of column 'x' in sheet 2

[Guest]

I have a summary table in sheet 1 that needs the totals from other sheets in
the workbook. the totals on the other sheets totals are on the last row of
the sheets however these rows constantly change.
Is there a way i can tell exceel to look at column b in sheet 2 and always
look at the last row for the amount?

 

[Ragdyer]

Try this:

=LOOKUP(99^99,Sheet2!B:B)

 

[Peo Sjoblom]

One way

=LOOKUP(2,1/(Sheet2!B1:B65535<>""),Sheet2!B1:B65535)

 

[Guest]

Thanks heaps for that!! Its made my day!!

Try this:

=LOOKUP(99^99,Sheet2!B:B)

 

[RagDyeR]

You're welcome, and appreciate the feed-back.