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

[µo°Ý] ½Ð°ÝÀx¦s®æ³sµ²ªº°ÝÃD

[µo°Ý] ½Ð°ÝÀx¦s®æ³sµ²ªº°ÝÃD

§Ú¦bSheet1ªºA1¥´¤J¤U¨Ò¤½¦¡
=Sheet2!A1
¡AµM«á¦bSheet2ªºA1¥´¤JABCD
°ÝÃD¨Ó¤F¡A·í§Ú¦b¦bSheet2´¡¤JÀx¦s®æ
¨ÏABCD¦r¥À©¹¤U²¾°ÊÅܦ¨Sheet2ªºA2
§Ú¦A¦^¨ÓSheet1¬ÝA1Àx¦s®æµo²{Åܦ¨
=Sheet2!A2
§Y¨Ï¥t¤½¦¡=Sheet2!$A$1
ÁÙ¬O·|ÅÜ­C¡I
½Ð°Ý¥ý¶i¬O¦p¦ó³B²zÀx¦s®æ¤ºªº¤½¦¡¤£·|ÀH¨ä¥LÀx¦s®æÅܰʦӦ³©ÒÅÜ°Ê
YOYO

=INDIRECT("Sheet2!a1")

TOP

¦^´_ 2# oobird

­è­è¸Õ¤F=INDIRECT("Sheet2!",A1)
¥X²{ªºµ²ªG«o¬O0
½Ð°Ý¸Ó­×¥¿­þ¸Ì©O¡H
·s¤â¾Çexcel

TOP

Sheet2!a1­YµL¼Æ¾Ú¦ÛµM¬O±o¨ì0ªº¡C

TOP

ÁÂÁª©¥D
¶¶«K¤@´£
¤½¦¡¬O=INDIRECT("Sheet2!a1")
¤£¬O=INDIRECT("Sheet2!",A1)
YOYO

TOP

¦^´_ 4# oobird


   ÁÂÁ¤F¡ãµo²{¬O " ¤U¿ù¦ì¸m
·s¤â¾Çexcel

TOP

¦^´_ 5# yanto913


    ¦]¬°§Ú¿ï¾Ü¨ç¼Æ®É¡Aexcel¦³¤@­ÓINDIRECT¨ç¼Æ
   ³o­Ó¨ç¼Æ¬OINDIRECT¡]ref_text,[a1])
    ´N¥H¬°­n¥[¤W³r¸¹....
    ¤£ª¾¹D³o¨â­Ó¤èªk­þ¸Ì¤£¦P¡H¡H¡H
·s¤â¾Çexcel

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2010-11-5 18:45 ½s¿è

¦^´_ 7# sujiuanjiuan
¨ç¼Æ»¡©ú
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
A1  ¬O­ÓÅÞ¿è­È¡F¥Î¥H°Ï§O ref_text ©Ò«ü©wªºÀx¦s®æ°Ñ·Ó¦ì§}¡A¬O¥H­þºØ¤è¦¡ªí¥Üªº¡C
¦pªG a1 ¬° TRUE ©Î³Q¬Ù²¤¤F¡A«h ref_text ³Q¸ÑÄÀ¦¨ A1 °Ñ·Óªí¥Ü¤è¦¡¡C
¦pªG a1 ¬° FALSE¡A«h ref_text ³Q¸ÑÄÀ¦¨ R1C1 °Ñ·Óªí¥Ü¤è¦¡
¡C
½d¨Ò
=INDIRECT("Sheet2!A1",TRUE)
=INDIRECT("Sheet2!R1C1",FALSE)

TOP

sujiuanjiuan ¶Ç¤@­Óªþ¥óµ¹§A
¤U¸ü¦^¥h¬ÝÀ³¸Ó´Nª¾¹D¤F

INDIRECT¨ç¼Æ.zip (2.27 KB)

YOYO

TOP

¦^´_ 8# GBKEE


    ·PÁ«e½úªº»¡©ú,Áö¨Ì§Úµ{«×ÁÙ¬O¦³ÂI¤£ÁA¸Ñ,
    ¬Û«HÄ~Äò§V¤O¤U´N·|¬ÝÀ´¤F
·s¤â¾Çexcel

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD