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

¬ÛÃöÅã¥Ü

¬ÛÃöÅã¥Ü

½Ð¦U¦ìÀ°¦£
§Ú·Q±N¬Û¦P«~¸¹§ì¦s©ñ¦ì¸mÅã¥Ü¨ì¥t¤@­Ó¤u§@ªí

¸ß°Ý.rar (7.14 KB)

¼Ë«~4½X¬O©T©w«á¥|­Ó¶Ü,¦pªG¬Oªº¸Ü,

E2==IFERROR(VLOOKUP(A2,¼Ë«~!A:E,5,),VLOOKUP(RIGHT(A2,4),¼Ë«~!A:E,5,))

TOP

¤j¤j,¤£¦n·N«ä,¨S¼Ð¥Ü²M·¡
§Úªº¹Ï­±¬O20½X
Y000E061009900000000
5ZF28000000000000000
Ãþ¦ü³o¼Ë
-----------
¨º¼Ë«~¬O
Y000E
ZF28
¦]¬°§Ú­Ì¥Ø«e¨t²Î¥æ´À,©Ò¥H·|¦³²£¥Í¦³ªº5½X¦³ªº4½X±¡ªp
¤w«e¨t²Î·|¦³¤@­Ó©T©w½X5¦b«e­±,¹ê»Ú¥Nªí¼Ë«~ªº½X¼Æ¬O5«á­±ªº¨º4½X,¬O¦³ªº5½X¦³ªº4½X§Ú¤£ª¾¹D«ç»ò§ì

TOP

¦^´_ 3# sheau-lan


    ¦^ÂЪº®É­Ô½Ð«ö©«¤l¤Uªº¦^ÂЫö¶s

¨º±ø¤½¦¡¥Îªº¤F¶Ü,¦pªG¦³¿ù»~ªº¸Ü,µ¹¤@¨Ç§ó¸Ô²Óªº¨Ò¤l

TOP

¦^´_ 4# fengetianxia


¤j¤j,§Ú­«¶Ç¤F,³o¼Ë»¡©ú²M·¡¹À?
³Â·Ð©p¦AÀ°§Ú¬Ý¬Ý,§Aªº¤u¬O§Ú¨ì¥Î¹D§Úªºªí®æ¨S¿ìªk¥Î,§Ú·Q¬O§Ú»¡±o¤£°÷²M·¡,¦A³Â·Ð§Aªº

¸ß°Ý.rar (9.99 KB)

TOP

H2= =IFERROR(IFERROR(VLOOKUP(LEFT(G2,5),¼Ë«~!A:H,8,),VLOOKUP(MID(G2,2,4),¼Ë«~!A:H,8,)),"")

TOP

¦^´_ 6# fengetianxia


    ¤j¤j,¥i¥H¥Î¤F,·P¿E¤£ºÉ,¯u±o«ÜÁÂÁ©p

TOP

¦^´_ 7# sheau-lan


    H2=IFERROR(LOOKUP(2,1/ISNUMBER(FIND(A2,¹Ï­±!$G$2:$G$8)),¹Ï­±!$H$2:$H$8),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

H2

=LOOKUP(,-FIND($A2,¹Ï­±!$G$2G$8),¹Ï­±!$H$2H$8)
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD