Body
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