How To Use Vlookup In Excel

             How To Use Vlookup In Excel

Hi and welcome to Myelesson! Here you can learn how to use Vlookup. This tutorial is also available in video format , to see the video version please Click Here For Video . 
 What Does Vlookup do: Vlookup finds a specific value for you based on a given criteria from a data range.
Lets understand the  vlookup formula =vlookup(lookup value,Table array, col_index_num,[range_lookup])

1. Lookup value = This the value based on which we excel would try to find your answer.Now we have to ensure that this lookup value should be present in the data range from where you want to get the result and the result which you are looking for should be on the right hand side of the lookup value,
2. Table array = This is the data range from which you want your result from , we should ensure that the data is sorted . The table array should be sorted also note that if the lookup value exists more than once in the table array then the 1st occurrence would be given as answer by Excel.
3. Col_Index_num = This is the column number from which excel would search for data in the table array. When counting the column number start counting from the  column which contains the lookup value  
4.  Range lookup = When you use a Vlookup formula excel gives you the option to look for either a exact match or a approximate match , 0 means exact match and 1 means approximate match . 

 See the Free Training Video

1. How To Use Vlookup (Hindi)
2. How To Use Vlookup (English)    

For more free videos visit www.myelesson.org