How to use vlookup function in Excel table Practical tutorial on vlookup function in Excel table

When we use Excel tables, we will use function formulas to calculate various data. Some of them need to be calculated through the vlookup function. Many people do not understand this formula, so they do not know the specific use method. So for this problem, In today's software tutorial, the editor will share the specific operation steps with the majority of users, hoping to be helpful to you. The actual operation steps of the vlookup function. Today we will use the vlookup function to find company employee information. You can follow the editor to operate it. 1. We need to double-click to open the excel software, select a blank cell at will, enter =vlookup( in the edit box, and click the fX button on the left side of the function bar.

2. In the pop-up function parameters dialog box, we want To query the employee number of the Beijing supervisor, enter the corresponding cell in Beijing in the lookup_value column

3. Select the contents of cells A4:C9 in the table_array column and enter 3 in the col_index_num column (indicating the third column of the selection range). , enter 0 in the range_lookup column (indicates precise search).

4. After clicking the OK button, we can see that the employee number of the Beijing manager has been found

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