What should I do if vlookup has a value but the result is 0?

What should I do if the vlookup has a value but the result is 0?

Cause: When fetching the values ​​of other cells, the "$" absolute reference is not used, which causes the corresponding fetching range to move downward when the formula is pulled down, and the data cannot be completely corresponding.

Recommended: "Excel Tutorial"

Solution:

1. Enter the keywords that need to be counted in the Excel table. You need to follow A Get the corresponding data from the contents of the column.

#2. Click "fx" in cell B2 to insert the function dialog box and select the vlookup function.

3. Then you need to add the "$" symbol in front of the address of the cell value area of ​​the tablearray to form: $D$1:$E$5.

#4. After generating the result of the function formula calculation, the value in column E can be taken out and filled into column B based on the data in column A.

The above is the detailed content of What should I do if vlookup has a value but the result is 0?. For more information, please follow other related articles on the PHP Chinese website!