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
