Articles → EXCEL → Vlookup In Excel

Vlookup In Excel






Software Requirement





Technical Knowledge





What Is A Table Array?




Picture showing the sample data in the excel file

Click to Enlarge




What Is Vlookup Function?





Syntax


VLOOKUP( value, table_array, index_number, [not_exact_match] )


  1. Value - value to search in the first column of the table array.
  2. Table array - range of cells in excel which represents data in tabular form (as mentioned in the section above)
  3. Index number – Column number in table array from which matching value must be returned.
  4. Range look up - A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match.

Example 1




Picture showing the sample data in the excel file

Click to Enlarge



  1. First of all select any 2 cells in the excel file. For this example I am using A11 and B11.
  2. Go to B11 and write the following formula
  3. =VLOOKUP(A11,A3:B7,2,FALSE)












Picture showing the N/A value when vlookup function is applied

Click to Enlarge



Picture showing the output of vlookup in excel

Click to Enlarge


Example 2




Picture showing the sample data in the excel file

Click to Enlarge



Picture showing the output of vlookup in excel

Click to Enlarge


Example 3




Picture showing the sample data in the excel file

Click to Enlarge



Picture showing the sample data in the excel file

Click to Enlarge





=VLOOKUP(N3,Grades,2,TRUE)




Picture showing the output of vlookup in excel

Click to Enlarge




Posted By  -  Karan Gupta
 
Posted On  -  Thursday, July 17, 2014

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250