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.

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.

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.

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.

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.

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.

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.

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.

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!