å åä¸ä¸ªåºç¡çä»·æ ¼è¡¨ï¼æææä¸åå称ãä¸åè§æ ¼çä»·æ ¼å½å ¥è¿å»ã并ç»å·¥ä½è¡¨å½åä¸ä¸ªææä¹çå称ï¼å¦âå价表âãå¦ï¼
2. æäºè¿ä¸ªåºç¡çå价表ï¼å°±å¯ä»¥ç¨æ¥æ¥è¯¢äºï¼æ¹æ³å¾å¤ï¼ç°å¨ç»åºæç´æ¥çå
¬å¼æ³ï¼ä¹å¯ä»¥ç¼åä¸åçå
¬å¼ï¼å¦å¾ï¼
F2=INDEX(å价表!D$2:D$11,MATCH(B2&C2,å价表!B$2:B$11&å价表!C$2:C$11,))
ä¸æå³å¯
追é®è°¢è°¢ï¼ç»çä¾åå¾è¯¦ç»ï¼ä½æ¯æåäºä¸ä¸ªåå¾çä¸æ¨¡ä¸æ ·çè¡¨æ ¼ï¼å¤å¶å ¬å¼è¿å»ï¼æ¥éäºï¼æ¾ç¤ºVALUE!
æç¹å¥æªï¼é¾éWPSä¸æ¯æè¿æ ·çè¿æ¥æ°æ®è·¨è¡¨å¼ç¨ï¼è¯è¯å®ä¹å称çæ¹æ³çï¼
å¨å价表ä¸ï¼å®ä¹3个å称ï¼åå«æBãCãD3åçæ°æ®åºåå®ä¹å称ï¼å¦ï¼
å称ï¼å¼ç¨ä¸ºB2:B11
è§æ ¼ï¼å¼ç¨ä¸ºC2:C11
åä»·ï¼å¼ç¨ä¸ºD2:D11
å
¬å¼ä¸çå¼ç¨å°±æ¹ä¸ºå称ï¼
=INDEX(åä»·,MATCH(B2&C2,å称&è§æ ¼,))
æè
åªå®ä¹ä¸¤ä¸ªå称ï¼å°å称åè§å®ç´æ¥å®ä¹ä¸ºä¸ä¸ªå称ï¼
å称è§æ ¼ï¼å¼ç¨ä¸ºB2:B11&C2:C11
å
¬å¼å°±æ¹ä¸ºï¼
=INDEX(åä»·,MATCH(B2&C2,å称è§æ ¼,))
æ¨ç¨çæ¯officeåï¼æè£ ä¸ªofficeè¯è¯ç