excel training class - Look-up Tables

Resolved · Low Priority · Version Standard

Look-up Tables

Philippa has attended:
Excel Advanced course

by - delegate Philippa [2 posts] (2008 Jan 25 Fri, 14:01) Reply

When is it best to use sum if functions aginst look up tables

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu	Bayswater	2	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	2	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
Full Schedule: See all 109 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Look-up Tables

by - trainer Amanda diamond contributer [1243 posts] (2008 Feb 7 Thu, 10:02) Reply

Hi Phillipa

Thank you for your question, and apologies for the delay in response.

If you could provide some more information about what it is that you want to be able to use these functions together for, that would help.

Thanks
Amanda

RE: Look-up Tables

by - delegate Philippa [2 posts] (2008 Feb 28 Thu, 17:07) Reply

Hi Amanda,

What I was trying to do was consolidate several spreadsheets into one. We are doing forecasts and there are 4 account handlers forecasting their results for the year and what I am trying to do is consolidate the results so that we can view the results of the whole team by looking at one sheet that I am trying to create.
I tried simply linking the cells in the 4 individual sheets which are in 4 different locations and it worked until a change was made and I am not sure how the links should be updated or whether this is not possible, but the consolidated spreadsheet was not updating.
Im not sure whether look up tables would work here or something else.
Might you be able to help?
Here's hoping! Many thanks, Philippa