Forum home » Delegate support and help forum » Microsoft Excel Training and help » VLOOKUP to transfer data
|
|
|
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. |
VLOOKUP to transfer data
Resolved · High Priority · Version 2003
Reply Wed 25 May 2011, 16:27Delegate Julie said...
Julie has attended:
Excel Intermediate course
VLOOKUP
How do I use VLOOKUP to transfer data from one workbook to another?
For upcoming training course dates see: Pricing & availability
RE: VLOOKUP
Hi Julie,
Thank you for your question and welcome the forum.
Use Insert and then function to bring up the function dialogue box. You will find the function in the lookup and reference category.
The first argument is the cell that contains the lookup value. The second argument is the range of cells in the other workbook you are trying to retrieve the data from. The third argument is the column number from the data set for the desired field value to be returned.
http://www.contextures.com/xlfunctions02.html
http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=446
I hope this answers your question.
Regards
Simon
|