ªð¦^¦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 : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD