:What should I do if the VLOOKUP result shows #N/A (4)-Table skills免费ppt模版下载-道格办公

What should I do if the VLOOKUP result shows #N/A (4)

Image and text skills

Today we will explain the last reason why the vlookup result is #N/A: the search value or data source contains other characters

When vlookup performs a search, the search value must be completely consistent with the content of the data source object, so if your search value or data source contains spaces, non-dash characters

print characters, then #N/A will definitely be returned, so they must be deleted. The deletion methods for different characters are different.

￭The number of tables and chairs in this table both returned #N/A errors

图一.png

￭The first situation is that there are spaces. Here you can quickly delete spaces through search and replace. Hold down Ctrl+H to bring up the replacement box and enter spaces in the search content item

Format characters, leave the replacement content empty, click to replace all;

图二.png

￭The number of "chairs" is obtained, but the number of "tables" is still wrong.

图三.png

￭This is the second situation. There are non-printing characters. What should I do? First, you can use = to determine whether the search value is consistent with the data source.

In any blank cellEnter =B2=G5, press Enter, false error result is returned, indicating inconsistency;

图四.png

￭At this time, you can use the Clean function to clear non-printing characters, enter =CLEAN(B2) in any blank cell, press Enter, and copy the result.

图五.png

￭Right-click cell B2 and select "Paste as value";

图六.png

￭At this time, the number of tables has also been obtained.

图七.png

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/VLOOKUP-jie-guo-xian-shi-N-A-zen-me-ban-si.html