ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð±Ð­n¨Ï¥Î¨º­Ó¨ç¼Æ¦^¶Ç

½Ð±Ð­n¨Ï¥Î¨º­Ó¨ç¼Æ¦^¶Ç

¦p´£ ´M§ä.rar (4.73 KB)

=VLOOKUP(A6,'2'!D:E,2,)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

ÁÂÁ ³o­Ó¦^¶Çªº¼Æ¶q¤£¹ï
¦ý°ÝÃD¦³¨â­Ó
1.§Æ±æ1ªí®æ¤¤¦³¦^¶Çªº¼Æ¶q¥[°_¨Ó
2.¨Ì1ªí®æ¤¤A6ªº¦WºÙ¦b2ªí®æ¤¤´M§ä¤@¼Ë¦WºÙ¨Ã±NQuantity¦^¶Ç¦ÜE6

TOP

¦^´_ 3# janejacky


    ¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/KufMyy

TOP

ÁÂÁÂ
¦ý¥i¯à§Úªí¹Fªº¤£²M·¡
1.§Æ±æ1ªí®æ¤¤¦³¦^¶Çªº¼Æ¶q¥[°_¨Ó~~¬O´XºØ ¤£¬OÁ`¼Æ  µª®×À³¬°4
2.¨Ì1ªí®æ¤¤A6ªº¦WºÙ¦b2ªí®æ¤¤´M§ä¤@¼Ë¦WºÙ¨Ã±NQuantityªº­È­n¦^¶Ç¦ÜE6~~ E6µª®×À³¬°5
   VLOOKUP(¦¡¤@,'2'!D:E,2,0)       ¦¡¤@¡BTRIM(A6)   
­n¦p¦ó°µ³o¨ç¼Æ     ¬O= VLOOKUP((TRIM(A6)  ,'2'!D:E,2,0))  ???

TOP

­è­è¥Î= VLOOKUP(A6,'2'!D:E,2,0) E6¹ïÀ³¨ì5
¦ý2ªí®æQuantityªº­È§ä¤£¨ì®É  E8 E9 E10  ·|¥X²{#N/A  ¥i¬OE10À³¸Ó­n¦^¶Ç2¤~¹ï°Ú

TOP

¦^´_ 5# janejacky

     1.§ó·s¬°­pºâ¦³¦^¶Ç¼Æ­Èªº­Ó¼Æ¡AE4¬°4
     2.E6¬°5¡BE10¬°2¡AµL»~

    ¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/KufMyy

TOP

¦^´_ 7# joblyc017

ÁÂÁÂ
¦ý§Ú¥Î³o¨ç¼Æ«á
   
E4¨Ï¥Î¨ç¼Æ =COUNTIF(E6:E11,"<>µL")  ¬O¬°¥¿½T­È  ¦ý¥i§_¤£­nÅã¥ÜµL
E6¨Ï¥Î¨ç¼Æ =IFERROR(VLOOKUP(A6,'2'!D:E,2,0),"µL")  ¸ò±zªºµª®×¤£¦P §Ú¿ù¦b­þ??

½ÐªÈ¥¿ ´M§ä1.rar (6.74 KB)

TOP

¥»©«³Ì«á¥Ñ joblyc017 ©ó 2018-1-2 16:42 ½s¿è

¦^´_ 8# janejacky

    ¼Ó¥Dªº¤½¦¡¡A¨Ã¥¼¨Ï¥ÎTRIM¨ç¼Æ¡A±Ð¾Çºô¯¸¤w¦³¤¶²Ð¨Ï¥ÎTRIM¨ç¼Æ¤§¥Î·N¡A½Ð²z¸Ñ«á¡A¦A¨Ì¹ê»Ú»Ý¨D¥h½Õ¾ã
    µù¡GExcel2003µLIFERROR¨ç¼Æ¡A¤U¹Ï¬°¤£¨Ï¥ÎIFERROR¨ç¼Æªºµ²ªG¡G
2018-01-02_163347.png

TOP

¦^´_ 9# joblyc017


   
ÁÂÁÂ
ÁٻݽбÐ

§Æ±æ1ªí®æ¤¤¦³¦^¶Çªº¼Æ¶q¥[°_¨Ó  =COUNTIF(E6:E11,">1")
¨Ì1ªí®æ¤¤A6ªº¦WºÙ¦b2ªí®æ¤¤´M§ä¤@¼Ë¦WºÙ¨Ã±NQuantity¦^¶Ç¦ÜE6  =IFERROR(VLOOKUP(TRIM(A6),'2'!D:E,2,0)," ")
2ªí®æ¤¤Quantity¦³¬°1   E12µL¦^¶Ç     
E12¤½¦¡=IFERROR(VLOOKUP(TRIM(A6),'2'!D:E,2,0)," ")
­þ¸Ì¦³°ÝÃD?? ´M§ä2.rar (4.66 KB)

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD