Home > Software Tutorial > Office Software > Excel uses vlookup to find graphic steps for projects

Excel uses vlookup to find graphic steps for projects

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2024-04-17 11:50:09
forward
457 people have browsed it

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.

Excel uses vlookup to find graphic steps for projects

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.

Excel uses vlookup to find graphic steps for projects

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

Excel uses vlookup to find graphic steps for projects

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.

Excel uses vlookup to find graphic steps for projects

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.

Excel uses vlookup to find graphic steps for projects

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!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template