Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Vlookups
|
|
|
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 training program - Vlookups
Resolved · Low Priority · Version Standard
Reply Wed 12 Dec 2007, 16:37Delegate Lyndsey said...
For upcoming training course dates see: Pricing & availability
Reply Fri 14 Dec 2007, 12:34Delegate Paul said...
RE: vlookups
vlookup stands for vertical look up. It looks for a unique value in a named range and returns the related figure in the desired column of that range.
It's useful if you have to relate a lot of data to one unique datum. e.g. userID or part number.
it saves you typing in the description of a part number over and over again, if you are for instance typing out a job list fort people to make things.
Also, if you have something such as a form to fill in for students, you would have a list of their student ID, their first name and their last name. On a seperate sheet you could type in their student ID which they would tell you and their first and last names would show up instantly where you told them to, using vlookup
Any more questions, gimme a shout
RE: VLOOKUPS
Dear Paul
Thank you very much for answering that VLOOKUP query!!
You have answered the question very well!!
In addition to what you have said all I would like to say is that this can be very useful if you have all the products or services information on one sheet and the customers personal info on the other, You can then create a new sheet with an invoice which can use the VLOOKUP to extract the info for the the product/service and the customer info in the relevant section of the invoice!!
Thank you again!!
Kindest Regards
Rajeev Rawat
|