ä¸ç¥éä½ é£ä¸ªæ¡ç éå¤ä¸ï¼å¦æä¸éå¤å¯ä»¥ä½¿ç¨VLOOKUPå½æ°ï¼
=vlookup(a1,sheet1!$a$1:$b$5,2,false)
æ¤å
¬å¼å¯å¤å¶å°B1åå
æ ¼éï¼å¾ä¸æ
å
¬å¼ç解éï¼a1,ç®æ æ°æ®ï¼sheet1!$a$1:$b$5ï¼æ¥è¯¢åºåï¼2ï¼æ¥è¯¢åºåç第äºåï¼å³ä½ çBåï¼æ°æ®è¿ååï¼ï¼falseï¼å¦ææ¥ä¸å°ï¼åé¦ç©ºå¼
追é®æ¯éå¤çï¼å°±æ¯ä¸ä¸ªå¤§çåºå表ï¼æè¿ä¸ªæçå
¥åºæ°æå
¥å¤§è¡¨çç¸åºä½ç½®