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

¦p¦ó°t¦Xvlookup¥\¯à±N¯Â¼Æ¦r«¬ºA¤é´ÁºI¨ú¥X¨Ó

¦p¦ó°t¦Xvlookup¥\¯à±N¯Â¼Æ¦r«¬ºA¤é´ÁºI¨ú¥X¨Ó

10306-12.rar (8.17 KB)
¦pªþ¥ó¯»¬õ¦â¶ñº¡¤§ªÅ®æ¸ê®Æ¡A¦p¦ó®Ú¾Ú10306-12¸ê®Æ§¨¤ºªº¥Ó½Ð¤é´ÁÄæÂà´«¬°ªì¼f·N¨£ªí¤º¤§¥Ó½Ð¤é´ÁÄæ¦ì¡H½Ð¦U¦ì«e½ú½ç±Ð¡AÁÂÁ¡I

¦^´_ 1# onegirl0204

B4 =MID(VLOOKUP($A4,'10306-12'!$B:$C,2,),1,3)
D4 =MID(VLOOKUP($A4,'10306-12'!$B:$C,2,),4,2)
F4 =MID(VLOOKUP($A4,'10306-12'!$B:$C,2,),6,2)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD