1、打开表格，将光标放在需要匹配的单元格上，点击上方的函数按钮。
/iknow-pic.cdn.bcebos.com/9c16fdfaaf51f3deeef1a5809aeef01f3b297996"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/9c16fdfaaf51f3deeef1a5809aeef01f3b297996?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/9c16fdfaaf51f3deeef1a5809aeef01f3b297996"/>
2、弹出窗口，选择“VLOOKUP”函数，点击“确定”。
/iknow-pic.cdn.bcebos.com/77094b36acaf2edde3b2550d831001e938019396"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/77094b36acaf2edde3b2550d831001e938019396?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/77094b36acaf2edde3b2550d831001e938019396"/>
3、在第一个方框内点击选择“苹果”。
/iknow-pic.cdn.bcebos.com/500fd9f9d72a60593c4afdfe2634349b023bbaff"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/500fd9f9d72a60593c4afdfe2634349b023bbaff?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/500fd9f9d72a60593c4afdfe2634349b023bbaff"/>
4、在第二个方框内，点击到“表二”，然后如图选择区域。
/iknow-pic.cdn.bcebos.com/37d12f2eb9389b5002bcfcb68b35e5dde6116e96"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/37d12f2eb9389b5002bcfcb68b35e5dde6116e96?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/37d12f2eb9389b5002bcfcb68b35e5dde6116e96"/>
5、在第三个方框内输入“2”，然后点击确定。
/iknow-pic.cdn.bcebos.com/91529822720e0cf3ded6521f0446f21fbe09aa34"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/91529822720e0cf3ded6521f0446f21fbe09aa34?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/91529822720e0cf3ded6521f0446f21fbe09aa34"/>
6、然后第一个单元格就匹配好了（看上方的函数，也可以在方框内直接输如图显示函数），双击单元格右下角。
/iknow-pic.cdn.bcebos.com/00e93901213fb80e3c927d3338d12f2eb8389496"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/00e93901213fb80e3c927d3338d12f2eb8389496?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/00e93901213fb80e3c927d3338d12f2eb8389496"/>
7、这样就自动全部填充好了。
/iknow-pic.cdn.bcebos.com/d788d43f8794a4c2e75bfbcf00f41bd5ac6e39dd"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d788d43f8794a4c2e75bfbcf00f41bd5ac6e39dd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/d788d43f8794a4c2e75bfbcf00f41bd5ac6e39dd"/>