Vlookupå½æ°çç¨æ³=VLOOKUPï¼æ¥æ¾å¼ï¼æ¥æ¾åºåï¼è¿åå¼å¨æ¥æ¾åºåçåæ°ï¼å¹é æ¹å¼ï¼ ï¼éè¿å©ç¨Vlookupå½æ°å¯ä»¥å¨ä¸ä¸ªå·¥ä½è¡¨ä¸å¹é å¦ä¸ä¸ªå·¥ä½è¡¨çæ°æ®ã
软件çæ¬ï¼Office2013
举ä¾è¯´æå¦ä¸ï¼
1.Sheet1ä¸æå¦ä¸å 容ï¼
2.å¨Sheet2ä¸è¾å
¥å¦ä¸å
¬å¼ï¼
=Vlookup(A1,Sheet1!A:B,2,0)
3.ä¸æå¡«å å ¬å¼ï¼å°±å¯ä»¥å®ç°å¯¹Sheet1ä¸æ°æ®çå¹é ã