VLOOKUP Function in Excel

Question

What is the VLOOKUP function in Excel?

Answer

Excel's VLOOKUP function, which stands for vertical lookup, is used to find specific information that has been stored in a spreadsheet table.  
The syntax for the VLOOKUP function is: = VLOOKUP ( lookup_value , table_array , col_index_num , range_lookup )  

  • lookup _value: The value you want to find in the first column of the table_array.
  • table_array: This is the table of data that VLOOKUP searches to find the information you are after.  

 
The table_array must contain at least two columns of data. The first column contains the lookup_values. 

  • col_index_num: The number of the column in the table_array that contains the data you want returned.  
  • range_lookup: A logical value (TRUE or FALSE only) that indicates whether you want VLOOKUP to find an exact or an approximate match to the lookup_value. Typing False will return exact matches only.  

For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3

If you need further assistance, please click the CTL Support Request button on this page

CTL Support Request Print Article

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.