Articles → EXCEL → VLookup in excel

VLookup in excel






















Software requirement





Technical knowledge





What is a table array?





Click to Enlarge




What is Vlookup function?





Syntax


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











Example 1





Click to Enlarge







=VLOOKUP(A11,A3:B7,2,FALSE)













Click to Enlarge




Click to Enlarge


Example 2





Click to Enlarge




Click to Enlarge


Example 3





Click to Enlarge




Click to Enlarge





=VLOOKUP(N3,Grades,2,TRUE)





Click to Enlarge




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

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250