æç §ä½ ç表å个Demoï¼
Sheet2ï¼
Sheet1ï¼
å¨Sheet1çJKLè¾å ¥å ¬å¼ï¼
J2:
=OFFSET(B$1,SMALL(IF(ISNA(MATCH(H$2:H$1000&B$2:B$1000,Sheet2!E$2:E$1200&Sheet2!F$2:F$1200,0)),65535,ROW($2:$1000)-1),ROW(A1)),)&""K2ï¼
=OFFSET(H$1,SMALL(IF(ISNA(MATCH(H$2:H$1000&B$2:B$1000,Sheet2!E$2:E$1200&Sheet2!F$2:F$1200,0)),65535,ROW($2:$1000)-1),ROW(A1)),)&""L2:
=IF(J2="","","第"&MATCH(K2&J2,Sheet2!E$1:E$1200&Sheet2!F$1:F$1200,0)&"è¡")以ä¸é½æ¯æ°ç»å ¬å¼ï¼ç»åé®Ctrl+Shift+Enterä¸é®ç»æè¾å ¥ã
J2K2L2ä¸èµ·ä¸æï¼å°±ä¼ååºææå¹é çæ°æ®ä»¥åå¹é æ°æ®å¨Sheet2çä½ç½®
é件å¯ä¸è½½åè