å¨è¡¨äº
B2=VLOOKUP(A2,表ä¸!A2:B11,2,FALSE)
C2=VLOOKUP(A2,表ä¸!A2:C11,3,FALSE)
éå®B2:C2ä¸æ
D2æ°ç»å ¬å¼ï¼Shift+Ctrl+Enterè¾å ¥)
=INDIRECT("表ä¸!D"&SMALL(IF(表ä¸!$A$2:$A$11=$A2,ROW(表ä¸!$A$2:$A$11),65535),MID(D$1,5,1)))
E2æ°ç»å ¬å¼ï¼Shift+Ctrl+Enterè¾å ¥)
=INDIRECT("表ä¸!E"&SMALL(IF(表ä¸!$A$2:$A$11=$A2,ROW(表ä¸!$A$2:$A$11),65535),MID(E$1,5,1)))
éå®D2:E2å³æè³M2
éå®D2:M2ä¸æ
æ0å¼è®¾ç½®æç©ºæ ¼ã