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:

<code>=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])</code>

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:

   <code>=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])</code>

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:

##1张三Sales2李思人事3王五Technology

Employee number	Name	Department

To find the name of the employee with employee number 2, you can use the following formula:

<code>=VLOOKUP(2, A2:C4, 2, FALSE)</code>

where :

• 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.

After pressing the Enter key, the cell will display the employee name "李思".

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!