1、创建excel,插入样例数据,
地名 代号
zhenjiang e
beijing f
shanghai g
nanjing h
guangzhou j
wuxi k
suzhou l
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2fdfc039245d6880ced60ddabc27d1ed31b24d8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、插入待匹配测试数据,
地名 代号
chongqing
beijing
shanghai
shenzhen
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/fc1f4134970a304ee5e07283dec8a786c8175c8d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在B2单元格,编写公式,=VLOOKUP(A2,sheet2!$A$2:$B$8,2,0),因未匹配到显示为#N/A,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1e30e924b899a9016a39864f12950a7b0208f5bf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、重新编写公式,=IFERROR(VLOOKUP(A2,sheet2!$A$2:$B$8,2,0),0),不存在的则显示为0,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bd315c6034a85edf08fcc25946540923dd547553?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)