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

½Ð°Ý¦p¦ó§ì¨ú¥t¤@¤u§@ªíªº¦X­p¸ê®Æ

¦^´_ 1# leiru
¦]¬°¦X­p¦r¼Ë¤£¦P¡A¤S¨S¦³®Æ¸¹¹ï·Óªí¡Aªí®æµL¤@©w®æ¦¡·|³y¦¨§ì¨ú¸ê®Æ§xÂZ
E22°}¦C¤½¦¡
=INDEX(INDIRECT("²£«~¥Ø¿ý!R"&MATCH(SUBSTITUTE(C22,"¦X­p",""),²£«~¥Ø¿ý!B:B,0)&"C5:R65536C5",0),MATCH("¦X­p",SUBSTITUTE(INDIRECT("²£«~¥Ø¿ý!R"&MATCH(SUBSTITUTE(C22,"¦X­p",""),²£«~¥Ø¿ý!B:B,0)&"C2:R65536C2",0)," ",""),0),)
Ch03-04.zip (18.06 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD