Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Vlookup
|
|
|
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+courses - Vlookup
Resolved · Low Priority · Version Standard
Reply Thu 24 Jan 2008, 14:05Delegate Carl said...
Carl has attended:
Excel Advanced course
Vlookup
If you vlookup from an external workbook, can this link to the external book be saved so as it will reference it even if that book is not open?
For upcoming training course dates see: Pricing & availability
RE: vlookup
Hi Carl
Thank you for your question.
The answer is yes, a link will be created between the two files which means that you don't need to have both files open for the vlookup to work. What you will find is that in the file where you have set up the vlookup formula, if you go to Edit - Links, there will be a link referencing the table data from the other file.
Excel will prompt you to choose if you want to updated the information in the file containing the link when it is opened.
I hope this helps.
Amanda
|