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

[µo°Ý] ½Ð°Ý¦U¦ì¥Îexcelªº°ª¤â­Ì!¦p¦ó¦¬´M«ü©wÀx¦s®æ¦ì¸mªº¸ô®|ÀÉ®×"¨ç¼Æ­n¦p¦ó³]

=INDIRECT("'"&B1&"[test2.xlsx]Sheet1'!$A2")

TOP

¤W¶ÇÀÉ®×µ¹¦U¦ì¥ý¶i¬Ý¬Ý¡A­þ¸Ì¦³°ÝÃD
Àɮקکñ¦b¸ô®|³Ì²©öªºD¼Ñ²Ä¤@¼h

TEST.rar (3.01 KB)

YOYO

TOP

¸Õ¸Õ³o­Ó¬Ý¬Ýindirect('B1&"[test2.xlsx]Sheet1'!$A2")

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-5-12 19:28 ½s¿è

¥~³¡³sµ²ªºÀɮץؿý¦r¦ê
§A§â¥ô¤@Àx¦s®æ¿é¤J=
µM«áÂI¿ï¸ÓÀɮתº¥ôÀx¦s®æ¡A¤½¦¡´N·|ª½±µÅã¥Ü¥X¨Ó¡A¨S¦³ºÏºÐ¥Ø¿ýªº¦ì§}
§â¸ÓÀÉÃö³¬«á´N·|Åã¥Ü¥X¥þ³¡ªº¥Ø¿ý¦r¦ê
¨Ì·Ó¸Ó¦r¦ê¨Ó¬Ý¸Ó«ç¼Ë«÷´ê¥X¸Ó¦r¦ê
test.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 17# Hsieh


    ª©¥D¤j¤j
¦b14¼ÓªºªþÀɧڤw¸g³o¼Ë°µ¤F¡A¥i¬O¤´µM¤£¦æ­C!
¥i¥H·Ð½ÐÀ°§Ú¬Ý¤@¤U¬O­þ¸Ì¦³°ÝÃD¶Ü?
YOYO

TOP

¥»©«³Ì«á¥Ñ jimmuLu ©ó 2011-5-13 10:28 ½s¿è

¦^´_ 18# yanto913


    Hello¡A§Ú¤]¦³³o­Ó°ÝÃD¡AHsieh¤w¸g´£¥Ü¤F¡A

¨ç¦¡¨S°ÝÃD¡A§Ú¥h¬Ý¤F»¡©ú¡A­ì¨Ó¬O§Ú­Ì¨Sª`·N¡AÀ³¸Ó¥ý¶}°Ñ¦ÒÀÉ«á¦A¶}®Ñ¼g¨ç¦¡¨º­ÓÀÉ´N¥i¥H¬Ý¨ì¤F¡C

PS:¤]´N¬O¥ý¶}2.xls¡A¦A¶}1.xls

»yªk

INDIRECT(ref_text,a1)

Ref_text   ¬O­Ó³æ¤@Àx¦s®æªº°Ñ·Ó¦ì§}¡F¦Ó³o­ÓÀx¦s®æ§t¦³¨Ì A1 ®æ¦¡©Î R1C1 ®æ¦¡©Ò«ü©wªº°Ñ·Ó¦ì§}¡B¤@­Ó©w¸q¬°°Ñ·Ó¦ì§}ªº¦WºÙ©Î¬O¤@­Ó©w¸q¬°°Ñ·Ó¦ì§}ªº¦r¦ê¡C¦pªG ref_text ¤£¬O¤@­Ó¦³®ÄªºÀx¦s®æ¦ì§}¡A«h INDIRECT ¶Ç¦^¿ù»~­È #REF!¡C

¦pªG ref_text «ü¦V¥t¤@­Ó¬¡­¶Ã¯ (¥~³¡°Ñ·Ó)¡A«h¨º­Ó¬¡­¶Ã¯¥²¶·¤w¸g¬O¶}±Òªº¡A§_«h INDIRECT ¶Ç¦^¿ù»~­È #REF!¡C

TOP

¦^´_ 19# jimmuLu


    ¥²¶·¶}±Ò¥t¤@­ÓXLS¡A¨ºÀ³¥Î­±´N¤ñ¸û¤Ö¤F
¦Ó¥BÀÉ®×¥²¶·¬O¶}±Òªº¡A©Ò¥H´N¤£»Ý³]©w¸ô®|
ª½±µ³]ÀɦW´N¦n¡A³]¸ô®|¤Ï¦ÓµLªk³sµ²
=INDIRECT("'"&B1&"[test2.xlsx]Sheet1'!$A2")
§ï¦¨
=INDIRECT("'"&"[test2.xlsx]Sheet1'!$A2")
YOYO

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD