å½æ°è§£å³
åå®ä½ è¾å
¥å¯¹åºç"åºåå·:å°±è½æ¾å°å¯¹åºç人åååä½(注æ:ææä½ ç第ä¸ä¸ªè¡¨æ ¼å½å为sheet1äº,å¦ææ¯ä½ èªå·±ä¿®æ¹äºåå,æä½ èªå·±ä¿®æ¹çååæ¿æ¢ä¸é¢çsheet1å°±å¯ä»¥äº)
å¨"å§å"åå
æ ¼ä¸è¾å
¥=vlookup(B2,sheet1!A:C,2,0)
å¨"åä½"åå
æ ¼ä¸è¾å
¥=vlookup(B2,sheet1!A:C,3,0)
温馨提示:答案为网友推荐,仅供参考