å·¥å ·ï¼office excel
æ¥éª¤ï¼
æ°å»ºä¸ä¸ªå·¥ä½è¡¨ï¼å½å为â1æâï¼å¹¶æç §ä¸é¢çå¾ç设置表头信æ¯ã
æ°å»ºä¸å¼ è¡¨æ ¼ï¼å½å为âæ°æ®è¡¨âï¼ç¨æ¥åå¨ãç©æç¼å·ãåãå称ãã
éä¸ãæ°æ®è¡¨ãçA1:B11åºåï¼ç¹å»ãå ¬å¼ã-ãå®ä¹çå称ã-ãæ ¹æ®æéå 容å建ãã
å¨å¼¹åºççé¢ä¸ï¼éæ©ãé¦è¡ãï¼å¹¶ç¹å»ãç¡®å®ãæé®ã
åå°â1æâç表ä¸ï¼éä¸Bå空ç½åºåï¼ç¹å»ãæ°æ®ã-ãæ°æ®æææ§ã- éæ©ä¸æèåä¸çãæ°æ®æææ§ãæé®ã
å¨å¼¹åºççé¢ä¸ï¼æç §ä¸å¾å¨ãå 许ãçä¸æèåéæ©âåºåâï¼å¾éãæä¾ä¸æç®å¤´ãï¼æ¥æºå¤è¾å ¥ï¼=ç©æç¼å·ã设置å®æåç¹å»ãç¡®å®ãæé®ã
ç¹å»Båç空ç½åå æ ¼æä¾çä¸æèåï¼å°±å¯ä»¥å¿«éå½å ¥ç©æç¼å·äºã
éä¸C4åå æ ¼ï¼åå»å¹¶è¾å ¥ï¼=IF(B4="","",VLOOKUP(B4,æ°æ®è¡¨!$A$1:$B$11,2,))ï¼è¿æ ·å°±èªå¨å¡«å äºB4åå æ ¼å¯¹åºçå称ãç¶åå°C4åå æ ¼çå ¬å¼ä¸æå¡«å ã
éä¸A4åå æ ¼ï¼åå»å¹¶è¾å ¥ï¼=IF(B4<>"",MAX(A$3:A3)+1,"")ï¼èªå¨çæåºå·ï¼å¹¶å¡«å ã
åªéè¦å¨Båéæ©ç©æç¼å·ï¼Aåçåºå·åCåçå称é½ä¼èªå¨çæï¼è¿éå表ä¹å°±å¤§è´å®æäºã
Excel如何制作进销存?这个视频告诉你!