ç»ä½ ä¸ä¸ªæ¹æ³ä½ å¯ä»¥è¯ä¸,æbook2çå
容å¤å¶ç²è´´å°book1çsheet2ä¸
ç¶åå¨book1çsheet1ä¸Aåæ°è¡è¾å
¥å
¬å¼
=index(sheet2!a:a,small(if(countif($a$2:$a$18,sheet2!$a$2:$a$14),4^8,row($2:$14)),row(1:1)))&""
æ°ç»å
¬å¼ä»¥ctrl+shift+enterä¸é®ç»åç»æè¾å
¥
å
¬å¼å³æä¸æå³å¯
温馨提示:答案为网友推荐,仅供参考