材料/工具:Excel2010
1、首先需要在同一个excel表格中,添加两个工作表。把第一个表格命名为:被引用表
![](https://iknow-pic.cdn.bcebos.com/7aec54e736d12f2e9ad4ca6c41c2d562843568ec?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、第二个表格命名为:引用后的表格。
![](https://iknow-pic.cdn.bcebos.com/023b5bb5c9ea15cece3b8705b8003af33b87b2e1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、只要在第二个表格中引用后数据出现的位置输入“=被引用表格的名字!需要引用数据位置”就行了,例如需要引用第一个表格中的编号,就可以输入:=被引用表!A2.
![](https://iknow-pic.cdn.bcebos.com/023b5bb5c9ea15cece718705b8003af33a87b21b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、完成上面步骤后,回车就出现了引用后的编号.
![](https://iknow-pic.cdn.bcebos.com/dbb44aed2e738bd402e2d53daf8b87d6267ff9ff?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、同样的道理,在相应的位置输入:=被引用表B2.
![](https://iknow-pic.cdn.bcebos.com/b2de9c82d158ccbf2532d23617d8bc3eb135412b?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/b3b7d0a20cf431addaed25354536acaf2edd98fa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、采用同样的方式可以引用第一个表格的出生年月日。
![](https://iknow-pic.cdn.bcebos.com/0dd7912397dda144a1fc0bbebcb7d0a20df486c0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、按照如上方法进行操作,最后就可以完成引用后的表格。
![](https://iknow-pic.cdn.bcebos.com/c8177f3e6709c93d2ddc68fb913df8dcd100548b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)