For those who have just learned Excel software, it is a bit difficult to use vlookup to find items. So how does Excel use vlookup to find items? Detailed steps are explained below.
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.
Frame the search range, which is the table on the left.
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 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 explains the detailed steps of using vlookup to find items in Excel. I hope friends in need can learn it.
