想要查找2个excel表格中的相同数据,并标记出来,可以按照以下步骤进行操作:
如下所示,【表一】和【表二】的两个工作表中,例如,需要在【表一】中查找出和【表二】相同的姓名具体步骤如下:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a2cc7cd98d1001e9f174809daa0e7bec55e797dc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8c1001e93901213f727bda4e46e736d12e2e95dc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第一步:录入查找相同内容的公式:
在【表一】空白单元格中输入=Vlo...,双击Vlookup进入。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/203fb80e7bec54e7fba48e8cab389b504ec26adc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第二步:输入需要赛选项、比对项中间用英文逗号隔开。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7aec54e736d12f2e764d3af25dc2d562843568dc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第三步:按ent键完成查找,鼠标放在单元格右下角,出现+号向下拖动鼠标,报错则是没有相同名字,反之就能找出相同名字。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b8389b504fc2d5625640447ff51190ef77c66cdc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
【加入社群一起学习】想要了解更多关于excel的相关信息,推荐咨询秒可职场。秒可职场团队规模已突破300人,秒可职场平台已上线数百门职场技能课程,平台累计用户数超过1000万并保持高速增长,在国内办公软件培训市场获得领先地位。秒可屡获资本青睐,先后获得腾讯和同道猎聘的战略投资。