1、首先需要在同一个excel表格中,添加两个工作表。要特别说明一下,下面介绍的方法必须在同一个表格中的两个工作表才可以使用。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3b292df5e0fe99250be08f563ba85edf8cb171cc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、如图,只要在第二个表格中引用后数据出现的位置输入“=被引用表格的名字!需要引用数据位置”就行了,例如需要引用第一个表格中的编号,就可以输入:=被引用表!A2。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/024f78f0f736afc36fdfd963bc19ebc4b64512e0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、完成上面步骤后,回车就出现了引用后的编号。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/29381f30e924b899935e9f3e61061d950a7bf652?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、同样的道理,在相应的位置输入:=被引用表!B2。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b151f8198618367af16099db21738bd4b21ce5cf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、点击回车,就出现了引用的姓名。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3c6d55fbb2fb4316384f9c7c2fa4462309f7d360?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、采用同样的方式可以引用第一个表格的出生年月日。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b219ebc4b74543a99e821cca11178a82b901141e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、按照如上方法进行操作,最后就可以完成引用后的表格,完成效果图。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/eac4b74543a98226d22acd218582b9014b90ebc9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)