没ææ ·è¡¨ï¼å¾é¾å¼çï¼ææå¯è½å¼åºæ¥ååä¸æ¯ä½ éè¦çã
å¦å¾1ï¼Sheet1ä¸çåºå·æ¯æå®çâåºå®æåºâ
ç°å¨Sheet2ä¸æä¸äºæ°æ®ï¼è¦æSheet1ä¸Aåçæåºæ¥éæ°æåºãå¦å¾2ï¼Aåçåºåæ¯ä¹±çï¼Bå对åºææ°æ®ãéæ°æSheet1æåºåçæ°æ®æ¾å°EååFåä¸ï¼å¨E2ä¸è¾å ¥å ¬å¼ï¼
=IFERROR(INDEX(A:A,INDEX(MATCH(Sheet1!$A$2:$A$26,Sheet2!$A$2:$A$25,)+1,SMALL(IF(ISNUMBER(MATCH(Sheet1!$A$2:$A$26,Sheet2!$A$2:$A$25,)),ROW($2:$26)-1,4^8),ROW(1:1)))),"")
åæ¶æCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼ï¼å³æå°F2ï¼åä¸æå°åºç°ç©ºç½åå æ ¼ã