How to use VLOOKUP function in excel table VLOOKUP detailed usage tutorial

The important role of VLOOKUP in Excel query The VLOOKUP function, as one of the three swordsmen of Excel query, plays an irreplaceable role in data search. It functions like a magical magician, able to extract exactly the required information from a designated area. This tutorial is carefully compiled by PHP editor Apple, aiming to help everyone gain an in-depth understanding of the usage and techniques of the VLOOKUP function. By reading this tutorial, you will master the rules and usage steps of the VLOOKUP function and easily handle various Excel query tasks.

After opening the table file, select the blank cell where you want to display the function result, and enter =VLOOKUP() in the blank cell.

Place the cursor in the brackets, click the mouse on the cell where the value needs to be found, and then enter,.

Here, I need to find the expense category through the expense category code, so click on the first cell E3 of the expense category code.

Then select the data table area range for the search value.

My region-wide data table is in another worksheet called Expense Category, so the expense category will appear! . As long as you enter, and select the area, the name of the data table will automatically appear.

Then add an absolute reference to the data table, that is, add $ to the left and right of the letters, and then enter,.

An absolute reference refers to the specified location. For example, here, the area I am looking for is specified in the area A3:B12.

Next, enter the number of columns where the value to be found is located in the lookup data table.

For example, here, the expense category I need to find is the second column in the selected area, so enter 2.

Enter, select exact match (ie FALSE), and press enter.

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