In this Vlookup tutorial we are going to look at how to use the Vlookup function. Essentially what this does is allow you to match up information from two lists and pull in matching information. An example would be if we have a list of part numbers and we want to pull in the actual stock levels for each part number from another worksheet or workbook. The vlookup function would be ideal in this case.
Watch the video below to see how its done.
[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/Vlookup_demo_2.m4v’]
You can download the original file here and check the solution here.
Here is t