æå
¥æç¹éº»ç¦ï¼å¯¹åºå表å¦å¤å¶ä½æ¹ä¾¿äºã
1ãè¥å表没æåºå·ï¼å¨aåæå
¥å¡«å
ï¼
2ãå设å表å¨sheet1,æ8å1000è¡ï¼
3ãå¨sheet2ï¼a1~h1æ·è´è¡¨å¤´ï¼
4ãa2å¡«å
¥åºå·â1âï¼b2è¾å
¥ =VLOOKUP(A2ï¼SHEET1!$A$1ï¼$H$1000ï¼2ï¼FALSE)
c2 =VLOOKUP(A2ï¼SHEET1!$A$1ï¼$H$1000ï¼3ï¼FALSE)
d2 =VLOOKUP(A2ï¼SHEET1!$A$1ï¼$H$1000ï¼4ï¼FALSE)
e2 â¦â¦ â¦â¦ â¦â¦ 5 â¦â¦
f2 â¦â¦ 6 â¦â¦
g2 7
h2 8
å
¬å¼æ¯ä¸æ ·çï¼å°±æ¯åæ°æ¯2æ¢å°8ãåºå·åªå¡«a2æ ¼ç1ï¼å
¶ä½çä¸è¦å¡«ï¼
5ãè¾å®åï¼å
¨éè¿16个åå
æ ¼ï¼a1ï¼h2ï¼ï¼ä¸æãæ设置好æ¡çº¿ååä¸æã
温馨提示:答案为网友推荐,仅供参考