VLOOKUP How to Excel in 60 Seconds
How to create a drop down list in Excel - • Video
VLOOKUP
VLookup is a very commonly used tool to find data in a list.
In this example I have a list of Products, Colour and Selling price
I’m creating a new table and I want to reference the names in this table to look up the sales price from this list and fill them in.
To do that I’m going to use the VLOOKUP function
Type =VLOOKUP
Lookup value is what value do I want to look up in the list – I want to look up the product Apple.
Table array is the list I'm going to choose from, so I will go to my data and select the entire list.
The column index number is the column that I want to return the value from, This is column 1, This is column 2 and and this is column 3 Sales price, we want the sales price so I will type column 3.
Finally, the range look up is true and false. If you choose True it looks for the closest match, False is the exact match, in almost every situation you want to use false. Hit OK and you can see that it looked up Apple in the table and found the Sale price and returned it up here.
All we have to do then is copy this data down.
Click here to watch how to create a drop-down list and incorporate it into a VLOOKUP or check out the other videos on my channel.