How to use vlookup function in excel

The VLOOKUP function is used in Excel to find a value in a vertical table and return the specified data in the corresponding row. Usage: Enter the function =VLOOKUP(lookup value, data table area, column number to return data, [match type]) in the cell, and replace the parameter value.

How to use the VLOOKUP function in Excel

The VLOOKUP function is a search and reference function, used in vertical Searches a table or list for a value and returns the specified data in the corresponding row. Its syntax is:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Parameter description:

• lookup_value: The value to be looked up.
• table_array: The data table or list area to be searched.
• col_index_num: The column number of the data to be returned.
• range_lookup (optional): Specify the match type. Defaults to TRUE (approximate match); if set to FALSE, an exact match is made.

Usage:

1. Select the cell where you want to enter the VLOOKUP function.

2. Enter the following formula:

   =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

   Copy after login

   Copy after login

3. Replace the parameter value:

   • Replace lookup_value with the value you are looking for.
   • Replace table_array with the data table or list range you want to search.
   • Replace col_index_num with the column number of the data to be returned.
   • range_lookup Optional, defaults to TRUE.
4. Press Enter.

Example:

Suppose you have a data table containing employee information as follows:

=VLOOKUP(2, A2:C4, 2, FALSE)

• A2:C4 is the data table area.
• 2 is the column number (name column) of the data to be returned.
• FALSE Specifies an exact match.

The above is the detailed content of How to use vlookup function in excel. For more information, please follow other related articles on the PHP Chinese website!