ããVLOOKUPå½æ°åªè½è¿åä¸ä¸ªç»æï¼å¦ææ³è¦ä¸å¯¹å¤æ¥è¯¢ï¼å¯ä»¥ä½¿ç¨å ¶ä»å½æ°ï¼çä¸è¾¹ä¾åï¼å°é¨é¨ä¸ºAçå§åå举å°Eåï¼
ããä¸ãä¸ä¸ªåå æ ¼æ¾ä¸ä¸ªååï¼E2å ¬å¼=IFERROR(INDEX(B:B,SMALL(IF(A:A=D$2,ROW(A:A)),ROW(A1))),"")ï¼æ°ç»å ¬å¼ï¼ä¸é®ç»æï¼
ããäºãå°Aé¨é¨çå§åæ¾å¨E2åå æ ¼ä¸ï¼ç¨éå·éå¼ï¼é¦å å°æ°æ®æé¨é¨æåºï¼ç¶åå¨E2å ¬å¼=MID(SUBSTITUTE(PHONETIC(OFFSET(A1,MATCH(D2,A2:A12,),,COUNTIF(A:A,D2),2)),D2,","),2,99)ï¼æ°ç»å ¬å¼ï¼ä¸é®ç»æã