V Look Ups

The UK's most regular instructor-led training courses.
Training information: excel word powerpoint courses london · Microsoft excel training · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Medium Priority · Version 2003

V Look Ups

Victoria has attended:
Excel Intermediate course

by - delegate Victoria [1 post] (2008 May 20 Tue, 16:05) Reply

Is it possible to create one Look up table saved in it's own file which could be then used in subsequent workbooks or would the look up chart need to be within a file

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: V Look Ups

by - trainer Stephen gold contributer [342 posts] (2008 May 21 Wed, 11:04) Reply

Hi Victoria

Thank you for your question

There is no problem here. You can create a file containing all your lookups.

When you want to build a formula that references the lookup, all you need do is open the lookup file and reference the cells in the lookup file using the function wizard.

Be aware however that if you subsequently move the lookup file, you may break the link.It is best therefore to keep the lookup file in the same folder as the other workbooks

Regards

Stephen