材料/工具:Excel2010
1、现在有两个表格,一个表格是工资表,需要引用另一个社保明细表格的相对应的人员的社保购买金额
![](https://iknow-pic.cdn.bcebos.com/8b13632762d0f7035360fdaa06fa513d2797c5f2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://iknow-pic.cdn.bcebos.com/9345d688d43f8794c0ca2358dc1b0ef41bd53a8a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在B2中输入=VLOOKUP
![](https://iknow-pic.cdn.bcebos.com/f636afc379310a553d13b582b94543a982261094?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、再选中姓名
![](https://iknow-pic.cdn.bcebos.com/a9d3fd1f4134970a7a9b78599bcad1c8a6865ddf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击姓名后,输入逗号,再选中你要引用的表格,这里就是SHEET2社保明细表,点击社保明细表后,打上逗号,再选择你需要引用的列,再打上逗号
![](https://iknow-pic.cdn.bcebos.com/4034970a304e251fdeff8f8ea986c9177f3e53bf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、然后输入你需要匹配的第几列数,这里是第二列,就是输入2,再打上逗号,然后输入0,0代表的是完全匹配
![](https://iknow-pic.cdn.bcebos.com/2f738bd4b31c8701096dda90297f9e2f0608ffe9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、然后敲击回车键,下拉复制当列就完成了
![](https://iknow-pic.cdn.bcebos.com/c75c10385343fbf2452acd55be7eca8065388f46?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、同理这里还需要要匹配另一个表格中的第三列数据,就输入3.回车就完成了
![](https://iknow-pic.cdn.bcebos.com/eaf81a4c510fd9f935613e1f2b2dd42a2834a456?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)