Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training class - Look-up Tables
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel training class - Look-up Tables
Resolved · Low Priority · Version Standard
Reply Fri 25 Jan 2008, 14:01Delegate Philippa said...
Philippa has attended:
Excel Advanced course
Look-up Tables
When is it best to use sum if functions aginst look up tables
For upcoming training course dates see: Pricing & availability
RE: Look-up Tables
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
Reply Thu 28 Feb 2008, 17:07Delegate Philippa said...
RE: Look-up Tables
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
|