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

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?

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

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Scott R" wrote in message
...
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?

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

One way

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


--

Regards,

Peo Sjoblom


"Scott R" wrote in message
...
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?

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

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

"Ragdyer" wrote:

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Scott R" wrote in message
...
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?

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

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

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Scott R" wrote in message
...
Thanks heaps for that!! Its made my day!! :)

"Ragdyer" wrote:

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Scott R" wrote in message
...
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?