98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Vlookup
excel+courses - Vlookup
Resolved · Low Priority · Version Standard
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?
Wed 6 Feb 2008, 21:07Trainer Amanda said...
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
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 tip:Switching Between SpreadsheetsAs the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet. |
