Excel uses vlookup to find graphic steps for projects

Take the table below as an example. The left side is the table to be queried, and the right side is the query result statistics table.

Enter the =VLOOKUP function in the form on the right, and then we select the conditions to be searched. Here we need to use the name to search, so select the name cell.

Box select the search range, which is the table on the left.

Then enter the number of columns where the target value you want to find is located. The number of columns here is the sales situation in column 2, so we enter 2.

Then determine the search method and enter 0 in the function, which means precise search. Finally fill in the right bracket and press Enter.

In this way, the sales status of a table is accurately extracted, and then the cells are filled in by drop-down, and the data of each person is accurately extracted.

The above is the detailed content of Excel uses vlookup to find graphic steps for projects. For more information, please follow other related articles on the PHP Chinese website!