ªð¦^¦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 : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD