????? ??????? ?????? INDIRECT ?????? ????? ?? Excel

?????? ????????? ?????? ?????????
???? ???????: 213933 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

?? Microsoft Excel? ???? ???? ????? INDIRECT ????? ??????? ?????? ?????? ???? ????????. ????? ??????? ???? ???? ????? INDIRECT ?????? ???????? ????? ??????? ????. ????? ????? ?? ??? ?? ?????? (??? ?????? ???? ???? ????? ????? ????) ?? ??? ??? ???????? ?????? INDIRECT ?????? ???? ????? ??????? ?? ??? ???????? ?? ???? ??? ????? ??????? ???????.

??????? ????

?????? ???? ?????? INDIRECT ??? ????? ???? ??? ??? ?????. ??? ?? ????? ???? ???? ??? ?????? ??? ?????? INDIRECT ??? ?????? ???? ?????? ???? ????? # #REF!. ???.

?????? ???? ????? ???????? ????? ??????? ?????? ?????? ?????? ?????? ????? ????? ??????? ??????? ???? ??????? ?? ??????? ???????.

???? 1

  1. ??? ????? Excel.
  2. ?? ??? ?????? A1 Book1? Sheet1? ????? ??? ??????.
  3. ?? Microsoft Office Excel 2003 ??? ????????? ??????? ?? Excel? ???? ??? ???? ??? ??? ???????? ???? ??? ??????? ?? ???? ??? ?????.
    ?? Microsoft Office Excel 2007? ???? ??? ?? Microsoft Office? ???? ??? ????? ??? ?? ???? ??? ?????.
    ?? Microsoft Office Excel 2010? ???? ??? ??????? "???"? ???? ??? ????? ?? ???? ??? ?????.
  4. ?? Book2? ???? 1? ??? ?????? A1 Book1.
  5. ?? Book2? ???? 1? ??? ?????? A2 ?????? 1.
  6. ?? Book2? ???? 1? ??? ?????? A3 A1.
  7. ??? ????????.
  8. ?? Excel 2003 ??? ????????? ??????? ?? Excel? ???? ?????? ??????? ?? Book2, ?????? 1, ?????? B1:
    = INDIRECT("'["&A1&".xls]"&A2&"'!"??? A3)
    ?? Excel 2007? ???? ?????? ???????:
    = INDIRECT("'["&A1&".xlsx]"&A2&"'!"??? A3)
    ???? ?????? ?????? "????? ??? ??????."

???? 2

?? Excel 2003 ??? ????????? ??????? ?? Excel? ????? ??????? ?????? ?? ?????? 1 ?? ??? ?????? ??? ????????? ??? ?? ?????? ???????:
= INDIRECT("'["&INDIRECT("A1")&".xls]"&INDIRECT("A2") ??? "'!"&INDIRECT("A3"))
?? Excel 2007 ? Excel 2010? ???? ?????? ???????:
= INDIRECT("'["&INDIRECT("A1")&".xlsx]"&INDIRECT("A2") ??? "'!"&INDIRECT("A3"))
???? ????? ?? ????? Excel ????? ???????. ???? 1 ????? ??????? A1? A2 ? A3 ??? ??????? ?????? ???????? ????? ?????? 2 ????? ??????? ???????? ?????? ???????? ??? ???????.

?????? INDIRECT ????? ??????? ??? ??????? ?????? ????????. ??? ?????? ?????? ???? ???? ??????. ??? ???? ??????? ??? ???? ?????? A1 ????? ??? ???? "? 1"? ? B1 ????? ??? ?????? "??????"? ?????? =INDIRECT(A1) ????? ??????? "??????".

??? ???? ???? ??? ???? ??????? ?????? ????? ????? ??????? ??????. ?? ?????? ?? ?????? ???????? ???? ?????? ??????? ?????? "? 1" ????? ?? ??????? ?????? B1.

???????

???? ???????: 213933 - ????? ??? ??????: 28/????? ??????/1434 - ??????: 6.0
????? ???
  • Microsoft Office Excel 2003
  • Microsoft Office Excel 2007
  • Microsoft Excel 2010
????? ??????: 
kbhowto kbmt KB213933 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????213933

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com