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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott R - 13 Sep 2007 05:34 GMT

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?

Reply to this Message

Ragdyer - 13 Sep 2007 05:41 GMT

Try this:

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

Signature

HTH,

RD

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

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

Reply to this Message

Scott R - 13 Sep 2007 05:54 GMT

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

> Try this:
>
[quoted text clipped - 6 lines]
> > 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?

Reply to this Message

RagDyeR - 14 Sep 2007 15:20 GMT

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

Signature

Regards,

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

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

"Ragdyer" wrote:

> Try this:
>
[quoted text clipped - 9 lines]
> > always
> > look at the last row for the amount?

Reply to this Message

Peo Sjoblom - 13 Sep 2007 05:41 GMT

One way

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

Signature

Regards,

Peo Sjoblom

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

Reply to this Message