excel training program - 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