Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I annotate a formula result in Sheet 1 in Sheet 2 by Cell Addr | Excel Worksheet Functions | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
Compare Sheet Cell to Sheet Column | Excel Worksheet Functions |