1、打开一个excel表,需要在另一个表中匹配出相应同学的班级信息。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f603918fa0ec08fa5d1833b856ee3d6d55fbda90?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、把光标定位在需要展示数据的单元格中,如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6609c93d70cf3bc702ccecf3de00baa1cc112ae4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在单元格中输入“=vl”,然后会自动提示出VLOOKUP函数,双击蓝色的函数部分。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3bf33a87e950352afd7a05175c43fbf2b2118b91?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、选择第一列中需要匹配数据的单元格,只选中一个就可以,然后输入英文状态下的逗号“,”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/11385343fbf2b211d2daa451c58065380cd78e3c?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/b999a9014c086e06e6ba1f540d087bf40ad1cb9b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、要返回的是表2中第四列的班级信息,所以在公式中再输入“4,”(逗号是英文的)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2934349b033b5bb5fbc300e139d3d539b600bc9c?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/574e9258d109b3de1eb3c477c3bf6c81800a4ca4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、如果想要把一列中的数据都匹配出来,只需要按下图操作。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3fb43166d224f4a3596530c06f790529822d1a5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
9、完成操作,最终效果如下。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e4dde71190ef76c6c06fdb349216fdfaaf51676b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)