Tue 20 May 2008, 16:05Delegate Victoria said...
Victoria has attended:
Excel Intermediate course
V Look Ups
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
Wed 21 May 2008, 11:04Trainer Stephen said...
RE: V Look Ups
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
