How to do Vlookup Formula in Microsoft Excel

How to do Vlookup Formula in Microsoft Excel


                        Many of our learners have told us they want to learn how to use Excel's VLOOKUP function. VLOOKUP is an extremely useful tool, and learning how to use it is easier than you think’

Before you start learning Vlookup Formula first we need to understand some of the basic rules in Vlookup

·                       Vlookup formula will only works when there is unique item in the both of the file. Eg. If I want to get the price of the product from the price list , we need to check whether this product is in the data base .

·                         Many of the users will be confusion in writing the Formula, In which cells they need to write the formula. Here we need to write the formula where we required the data from the Database



Formula Description


·        Lookup Value is Value which is in our file which is matching with Database. Eg. If we need the price of the product from the database and here the lookup value is Product Range.



·        Table array of the Lookup functions should be start from the Similar Value Eg. While selecting the table array it should be start from the Product column to the range we require and also make the selection in the absolute range in Dollar sign or locking the range by the short key F4.

·        Column Index is option which we need to put the column number which the table array starting to require column. Egg In the pricelist the we need Item Group and Price, For getting the Item Group the Column Index will be 2 ,because the number of the column from the Product to Item group is 2 Including the product column. If in the case of Rate it will be 3.

·        Range Lookup is area where we need to provide the criteria for exact match of approximate matched Exact match we need to write” 0” or “False” and for the approximate match we need to write “1” or “True”


Click here for Excel File

Click Here: How to Copy Visible Cells only

Watch the Full VLookup Tutorial in Excel in Malayalam by clicking in below link

Video Link: Watch Video

Phone : +91 8606648045
Email :
Excel Skill Corner
Kerala, India.