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!