首先我们需要在同一个excel表格中,添加两个工作表。要特别说明一下,下面介绍的方法必须在同一个表格中的两个工作表才可以使用。
我把第一个表格命名为:被引用表,第二个表格命名为:引用后的表格。
![](https://iknow-pic.cdn.bcebos.com/d52a2834349b033b3e3b2d4e19ce36d3d439bdf7?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/cf1b9d16fdfaaf515312502b805494eef11f7ab5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
如图,只要在第二个表格中引用后数据出现的位置输入“=被引用表格的名字!需要引用数据位置”就行了,例如需要引用第一个表格中的编号,就可以输入:=被引用表!A2.
![](https://iknow-pic.cdn.bcebos.com/b90e7bec54e736d1bee25d9c97504fc2d46269b5?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/622762d0f703918f9e98ec5e5d3d269758eec4dd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
同样的道理,在相应的位置输入:=被引用表!B2.
![](https://iknow-pic.cdn.bcebos.com/fcfaaf51f3deb48f2e98704afc1f3a292cf578b5?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/8d5494eef01f3a298b39045a9525bc315d607cb5?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/64380cd7912397dddaf249905582b2b7d1a2879f?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/8435e5dde71190efec0a434bc21b9d16fcfa60b5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)