excel里用VLOOKUP函数取同时满足两个条件的值,可以按照以下步骤进行操作:
例如,有一组数据A,包括姓名、学号、成绩三列,另外一组数据B有姓名、学号两列,现在要将数据A的成绩关联到数据B中来。如下图所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/503d269759ee3d6dd518105951166d224e4ade42?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
1、在I2单元格输入数组公式:=VLOOKUP(G2&H2,IF({1,0},$A$2:$A$8&$B$2:$B$8,$C$2:$C$8),2,0),然后按按
组合键结束输入。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3c6d55fbb2fb4316eec1ede832a4462308f7d342?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/54fbb2fb43166d22cba98206542309f79152d242?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/42166d224f4a20a4c0c0ab5582529822730ed042?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
【加入社群一起学习】
想要了解更多关于excel的相关信息,推荐咨询秒可职场。秒可职场将持续投入产品与课程内容的研发升级,积极拓展更多前沿职场课程,并开拓B端企业培训服务市场。“秒”代表“分秒、时刻”,“可”代表“可以、认可”,秒可致力于帮助广大职场人终身学习成长、获得认可和成就,实现共同富裕。