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

[µo°Ý] ¤U©Ô¦¡¿ï³æ

[µo°Ý] ¤U©Ô¦¡¿ï³æ

½Ð°Ý¦U¦ì°ª¤â¤j¤j
Ãö©óªþ¥ó·í¤¤·í§Ú§ïÅÜC1ªº¤U©Ô¦¡¿ï³æ¤º®e®É
¨ä¥L©Ò¦³Àx¦s®æªº¸ê®Æ¤]³£¸òµÛÅܧó
µM«á¥h¬Ý¸Ì­±¦³¥Î¨ìOFFSET
¦ý¹ï©ó¸Ì­±B3Àx¦s®æ=OFFSET(Y!$A$11,MATCH($C$2,Y!$C$11:$C48345,0),1)¯uªº¤£¤Ó¤F¸Ñ¥Lªº·N«ä¥i§_½Ð¤j¤j«ü¾É¤@¤U
¥H¤ÎC3Àx¦s®æ¸Ì¬°=VLOOKUP(B2,code!A2:B$935,2,FALSE)¦³¥Î¨ìVLOOKUP
¦ý¬O¸Ì­±ªºcode!A2:B$935³o³¡¤À¨ì©³¥Lªº½d³ò¨ì©³Âæb­þÃä©O
Àµ½Ð¤j¤j«ü¾É¤@¤U
·P®¦
Sample.rar (124.28 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2014-4-8 09:26 ½s¿è

¦^´_ 1# pideo
1¡B·Æ¹«²¾¦Ü¤u§@ªí¦WºÙ«áÂI«ö¥kÁä¡A­Ó§O¨ú®øÁôÂêºY¡BS¡BD»Pcode¤u§@ªí¡C
2¡B¤À§O¦b¤u§@ªíY¡BS¡BD»Pcode¨ú®øªº¨ä³QÁôÂ꺦C¡A¥þ¿ï¤u§@ªí«áÂI«ö·Æ¹«¥kÁä¡A°õ¦æ¡u¨ú®øÁôÂáv¡C
3¡BB3Àx¦s®æ=OFFSET(Y!$A$11,MATCH($C$2,Y!$C$11:$C48345,0),1)·N«ä¬°¡G¥HY!$A$11¬°°_ÂI¡A¦V¤U²¾°ÊMATCH($C$2,Y!$C$11:$C48345,0)¡u¦C¡v¡A¦V¥k²¾°Ê1¡uÄæ¡v¡A¨ú±o¹ïÀ³­È¡C
½Ð°Ñ¦Ò¡I

TOP

­ì¨Ó¬OÁôÂð_¨Ó¤F
Ãø©Ç§Ú¤@ª½§ä¤£¨ì
­ì¥»ÁÙ¥H¬°¸Ì­±°Ñ¼Æ¬O¤£¬O¦³¨ä¥L¥È¾÷ªº»¡
·PÁ¤j¤j«ü¾É
·P®¦

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD