Excel中不显示“#N/A”信息方法:
1、以Excel2016为例,假设要将下图中显示#N/A”信息的单元格显示为空。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/ac345982b2b7d0a22a6e0dc6c5ef76094a369ac1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、这里需要将左边产品的销量匹配到右边,先在单元格中输入公式=VLOOKUP(G2,$A$2:$B$10,2,0),下拉公式后发现,单元格H3出现了“#N/A”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f3d3572c11dfa9ec54765e4c6cd0f703918fc115?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在刚刚的公式前面加入IFERROR公式,即在H2写入公式=IFERROR(VLOOKUP(G2,$A$2:$B$10,2,0),""),表示当返回值为错误信息时,该单元格显示为空。下拉公式后,发现H3以已显示为空。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bd3eb13533fa828bc2df96b8f31f4134960a5ae8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)