F2:
=IFERROR(INDEX(B:B,SMALL(IF(($A$2:$A$10=$E2)*(B$2:B$10<>""),ROW($2:$10)),1)),"")
ctrl+shift+回车,右拉下拉
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/30adcbef76094b36a709748cb3cc7cd98d109d33?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追问函数输入后,ctrl+shift+回车空白
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8ad4b31c8701a18b2e547c2e8e2f07082838fe10?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追答E2:
=INDEX(A$2:A$1000,MATCH(0,COUNTIF(E$1:E1,A$2:A$1000),))&""
ctrl+shift+回车
追问很厉害,基本解决了我的问题,不过为了简化,我要处理的表格比这个稍微复杂一点点,大神有微信吗,能向你请教吗?照着你的代码改了下,谢谢,可以了
追答=Z721400
去掉等号
本回答被提问者采纳