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

[µo°Ý] (¤w¸Ñ¨M)if+vlookupªº¤½¦¡¦³¨S¦³¿ìªk²²¤

[µo°Ý] (¤w¸Ñ¨M)if+vlookupªº¤½¦¡¦³¨S¦³¿ìªk²²¤

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-3-22 08:29 ½s¿è

µo°Ý¤§«e°Ý¤@¤U ¦³¤Hª¾¹D¬°¤°»ò¦b¤j³°¤W³Â»¶®a±ÚÁÙ­nª¦Àð¤~¯à¤W?

=VLOOKUP($A2,INDIRECT("'"&C1&"'!A2:L1600"),4,0)
§Úªº¤½¦¡¬O³o¼Ë²Ä´XÄ樺­Ó¼Æ­È§Ú·Q­nÅý¥¦ÅÜ°Ê
¦pªGÀx¦s®æa1¬°a«h¬°4 b«h¬°8 c«h¬°12
¥Ø«e§Ú¯à·Q¨ìªº´N¬O¦b¸Ì­±¥[if
¦³§Oªº¤è¦¡¥i¥H³B²z¶Ü?

¦]¬°ª¦À𤧫á«Ü¶w ÀɮפW¶Ç¤£¤F §Æ±æ¦U¦ì¨£½Ì
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-3-21 20:47 ½s¿è

¦^´_ 1# freeffly
¦Ü©ó¤j³°µLªk¤W³Â»¶¡A¥i¯à°Ý°Ý¹ï©¤°ª¼h·|¤ñ¸û²M·¡
¥»½×¾Â¬OµL°ê¬Éªº

    =VLOOKUP($A2,INDIRECT("'"&C1&"'!A2:L1600"),(CODE(A1)-96)*4,0)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ªO¥D§A¥Îcodeªº¤è¦¡§Ú¦³¬Ý¹L
   ¤£¹L§Úªºabc¥u¬O¤@­ÓÁ|¨Ò
   §Ú¬O¥Î¨ä¥L¤¤¤å¦r§PÂ_
   ¤£ª¾¹D³oºØ¬O¤£¬O´N¥u¯à¨Ä¨Ä¦b¸Ì­±¥Îif?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 3# freeffly

¨º´N§ä¬Ý¬Ý¤å¦rªº¦@³q©Ê¡A­Y¬O¤å¦rºØÃþ«Ü¦h´N»s¦¨ªí®æ¡A°£¤F¥i¥ÎMATCH§ä¨ì¦ì¸m¡AÁÙ¥i¥Î¨Ó·í¦¨A1ªºÅçÃÒ²M³æ¡A´N¬Ý§A¦p¦ó³]­p?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    ¼È®É¤w¸g¥ý¥Hif³B²z
   ªO¥D»¡ªº¤è¦¡´£¨Ñ¤F·s«äºû
   ÁÂÁÂ
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

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