As well as Vlookups being incredibly useful, at this present time this seems to be a benchmark of your Excel knowledge if you are looking for a new job – so good to know how to do it, even if you don’t have to use it.
A Vlookup stands for Vertical Look up and is used to find information from a list by basing it on the information you have already entered. For example, you enter a product code number into one cell, it can find the item description from a huge list of products and pop it into the next cell as in an invoice. It can do the same for the price, this means you only have to enter the product code once and everything else can be automatically populated.
Here’s how: For this I am going to use the example of an invoice. I only want to enter the product code and I want the corresponding information – price and description to be filled in from Vlookups.
NB – Very important the data you want to reference, in my example the ‘Product code’,
When you have entered all this info in you can see the result of the formula in the box. If it is not correct you can go back and change the formula, if it is click Ok.
If you wish to drag the formula down into the other boxes on your invoice you will need to make it an ‘Absolute cell reference’. After you have highlighted your ‘Table_array’ hit the F4 key, this will automatically enter the $ in the correct places.
This is covered in our Excel Advanced training course.
This Microsoft Excel Essentials training course will introduce you to the basic skills needed […]Read more
This intermediate Microsoft Excel training course is suitable whatever version of Excel you use […]Read more