Home > Topics > excel > What to do if there is an error in the drop-down function of vlookup function

What to do if there is an error in the drop-down function of vlookup function

藏色散人
Release: 2020-05-11 10:09:35
Original
31460 people have browsed it

What to do if there is an error in the drop-down function of vlookup function

What should I do if the vlookup function fails to pull down?

First open the data table to be referenced, and then copy the object to be found into this table, and place it as needed.

What to do if there is an error in the drop-down function of vlookup function

I positioned the cursor in the K2 column and entered the formula here. Sometimes if you are not familiar with it, you can find it in the menu bar above.

What to do if there is an error in the drop-down function of vlookup function

In the formula, click the drop-down arrow to the right of Find and Apply, find the vlookup function at the bottom and click it.

What to do if there is an error in the drop-down function of vlookup function

The function parameter dialog box will appear. You can enter it here or click to select it. I want to find the value in cell I2. You can click it and enter the following. Find the data table, you can drag and drop to select it, and then enter the content of the column I want to return. Finally enter the matching criteria.

What to do if there is an error in the drop-down function of vlookup function

The result will come out, then put the mouse on the lower right corner of cell k2 and drag it down, but the result #N/A appears in the result, this What's the problem? This person is clearly in my search data table.

What to do if there is an error in the drop-down function of vlookup function

When I put the mouse on the cell with the problem, when I checked the formula, I found that there was a problem with the area I was looking for, not all the areas I selected, but It has changed downward.

What to do if there is an error in the drop-down function of vlookup function

Enter a few $ here in the search area, so that you can absolutely reference the area you just selected. Of course, you need to do this again in cell k2.

What to do if there is an error in the drop-down function of vlookup function

Then select the K2 cell, put the mouse on the lower right corner of the cell, when a small black cross appears, drag it down to fill in the cells below. , you can also double-click the left mouse button here.

What to do if there is an error in the drop-down function of vlookup function

The above is the detailed content of What to do if there is an error in the drop-down function of vlookup function. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
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