EXCELéé¢æ两个工ä½è¡¨ï¼å设ä¸ä¸ªæ»è¡¨æç§ç±»åä»·æ ¼çå«Sheet1ï¼ä¸ä¸ªæ¯ä½ è¦ä¹°ä¸è¥¿çç§ç±»çå«Sheet2ï¼æ°æ®é½æ¯âç§ç±»âå¨Aåãâä»·æ ¼âBåï¼ç¬¬ä¸è¡æ¯è¡¨å¤´ã
å°±å¨Sheet2çB2è¾å
¥
=VLOOKUP(A2,Sheet1!A:B,2,)
æ
=IF(A2=ââ,ââ,VLOOKUP(A2,Sheet1!A:B,2,))
å车并åä¸å¡«å
ã
温馨提示:答案为网友推荐,仅供参考