???? ???????: 291073 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? Microsoft Excel ????? ???? ?????? ?????? ???? ??????. ????? ??????? ????? ?????? ??? ?? ????? ????? ???? ???????? ??? ????? ????????. ???? ???? ??????? ???? ???????? ???????? ??????? ??????? ?????? ??????? ???????? ?????? ??????? ?? ????? ??????? ?? ???? ???????.

??? ???? ????? ???? ???? ??? ???? ??? ????? ????? ???????? ????? ????? ???? ????? ?????? ?????? ????? ??????. ????? ??????? ??? ?????? ??????? ?? ???? INDEX ?????? ????? ?????? ?? ???????.

???? ????????? ??????? ??????? ???????? ???????? ??????? ??????? ?????? ??????? ???????? ?????? ???????. ??????? ??????? ??? ??????? ??????? ?????? ????? Index.

???????? ????? ???? ??????? ?? Microsoft Office Excel 2007? ??? ????? ????? ????? ??????. ?????? ????? ???? ??? ???????:
  1. ???? ??? ?? Microsoft Office? ?? ???? ??? ?????? Excel.
  2. ?? ????? ??????? ????? ???? ?????? ???? ???????? ????? ????? ????? ?????? ?? ??????? ?? ???? ??? ?????.

???????? ????? ???? ??????? ?? Microsoft Office Excel 2010? ??? ????? ????? ????? ??????. ?????? ????? ???? ??? ???????:

1. ???? ??? ????? ????? ???? ??????? ????? ??????

2. ??? ????? "????? ??????"? ?? ????? ?????? ?? ???? ??????.

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

  1. ?? ???? ??? ?????? ???? ??????? ??????? ?? ?????? ?? H1 ??? H20:
          H1: ????? ????
          H2: ???? ????? ?????
          H3: ????
          H4: ???
          H5: ?????
          H6: ????? ?????
          H7: ????? ??????
          H8: ?????
          H9: ??????
          H10: ????
          H11: ????
          H12: ??????
          H13: ?????
          H14: ??????
          H15: ????
          H16: ?????
          H17: ????
          H18: ?????? ?????
          H19: ???? ????? ?????
          H20: ??? ????
    					
  2. ?? ?????? A1? ???? ?????? ???????:
    =INDEX(H1:H20,G1,0)

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

  1. ?????? ???? ????? ?? Microsoft Office Excel 2003 ??? ??????? ????? ?? Excel? ???? ??? ???? ???? ????? ?? ???? ??????? ?????. ?? ?? ??? ??? ?????? ???? ????? ???? ??????? ?? B2 ??? E10.

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

    ??????? ???? ????? ?? Excel 2007? ???? ??? ????? ????? ??????? ????? ??? ?????? ?? ???? ??? ???? ????? ?? ????? ????? ???? ???????.
  2. ???? ??? ?????? ?????? ??? ???? ???????? ?? ???? ??? ????? ???? ????. ???? ????????? ???????? ?? ???? ??? ?????.
    1. ?????? ?????? ???????? ???? H1:H20 ?? ?????? ???? ???????.
    2. ?????? ???? ????? ?? ?????? G1 (????? ?????? ???? ?? ?????? ?? ???????)? ???? G1 ?? ?????? ?????? ??????.

      ?????? ?????? ???? INDEX() ?????? ???????? ?? G1 ?????? ???? ??????? ???????.
    3. ?? ??? ???????? ???? ?? ????? ?????? ????. ???? ??? ?????.

      ?????? ???? ????????? ?? ???????? ????? ?????? ??? ?? ???? ??????? ????? Microsoft Visual Basic for Applications ?????? ??? ???????. ???? ????? ?? ???? ???????? ????? ????? ??????? ???? ?????? ????? ??????? ??? ???? ???????.
??? ?? ???? ???? ??????? ???? ????? ???????. ???????? ???? ???????? ???? ??? ??? ???? ?? ??????? ??? ?? ??? ????? ???? ???????. ?? ???? ????? ??? ??? ????? ???????? ??? ????? ?????? G1 ??? ??? ???? ??? ???? ?????? ???? ?? ?????? ?? ???????. ?????? ?????? INDEX ?? ?????? A1 ??? ????? ???? ??? ??????.

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

  1. ?????? ???? ????? ???? ?? Excel 2003 ??? ??????? ????? ?? Excel? ???? ??? ???? ???? ????? ???? ?? ???? ??????? ?????.

    ??????? ???? ????? ???? ?? Excel 2007 ?2010? ???? ??? ????? ????? ??????? ????? ??? ?????? ?? ???? ??? ???? ????? ???? ?? ????? ????? ???? ???????.
  2. ????? ???? ???? ??????? ?? B2 ??? E2.
  3. ???? ??? ?????? ?????? ??? ???? ??????? ??????? ?? ???? ??? ????? ???? ????. ???? ????????? ???????? ?? ???? ??? ?????:
    1. ?????? ?????? ???????? ???? H1:H20 ?? ?????? ???? ???????.
    2. ?????? ???? ????? ?? ?????? G1 (????? ?????? ???? ?? ?????? ?? ???????)? ???? G1 ?? ?????? ?????? ??????.

      ?????? ?????? ?????? INDEX ?????? ?? G1 ?????? ???? ??????? ???????.
    3. ?? ?????? ?????? ????????? ???? ??. ???? ??? ??????? ??? ??????? ???? ???? ????? ??? ?? ????? ????? ??????? ???? ????? ???? ??????? ??????.

      ?????? ???? ???????? ????? ????? ??????? ?? ???? ???????? ???? ?????? ????? ??????? ??? ?????? ??????? ?? ???? ??????? ??????.
??? ?? ???? ?????? ??????? ?? ???? ??????? ?????? ????? ???????. ???????? ?????? ??????? ?? ???? ??????? ??????? ???? ??? ??? ???? ??? ?? ??? ????? ??????. ??? ????? ??? ??? ????? ?????? ??????? ?? ???? ??????? ??????? ??? ????? ?????? G1 ??? ??? ???? ??? ???? ?????? ???? ?? ?????? ?? ???????. ?????? ???? INDEX ?? ?????? A1 ??? ????? ???? ??? ??????.

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

  1. ?????? ?? ????? ?????? ?? Excel 2003 ??? ??????? ????? ?? Excel? ???? ??? ???? ????? ?? ????? ?? ???? ??????? ?????? ?? ?? ??? ??? ?????? ?? ????? ?????? ???? ??????? ?? B2 ??? B3. ?? ?????? ??? ?? ??????? ???????? ????? ????? ??? ??? ??????.

    ??????? ?? ????? ?????? ?? Excel 2007 ?2010? ???? ??? ????? ????? ??????? ????? ??? ?????? ?? ???? ??? ?? ????? ?????? ?? ????? ????? ???? ???????.
  2. ???? ??? ?????? ?????? ??? ?? ??????? ????????? ?? ???? ??? ????? ???? ????. ???? ????????? ???????? ?? ???? ??? ?????:
    1. ?? ?????? ?????? ???????? ???? ?.

      ???? ??? ?????? ?? ??????? ???????? ??? ???? ?????? INDEX ??? ??? ???? ?? ???????.
    2. ?? ?????? ?????? ??????? ???? ?.

      ???? ??? ?????? ??? ???? ?? ???? ?? ??????? ???????? ??? ?????? ????? ?? ???????.
    3. ?? ?????? ?????? ??????? ???? ??.

      ???? ??? ????? ???? ?????? ???? ????????? ?? ???????.
    4. ?? ?????? ??????? ????????? ???? ?.

      ????? ??? ?????? ?? ????? ????? ???? ???? ??????? ???????? ?????? ???????.
    5. ?????? ???? ????? ?? ?????? G1 (????? ?????? ???? ?? ?????? ?? ???????)? ???? G1 ?? ?????? ?????? ??????.
???? ??? ??? ???? ??? ?? ??? ????? ?? ??????? ????????. ??? ????? ??? ???? ?????? ????? ?? ???? ?????? ????? ??? ?? ??????? ????????? ??? ????? ?????? G1 ??? ??? ???? ??? ?????? ??????? ??? ??????? ???????? ???? ?? ???? ???? ??????? ???????? ??? ??????? ????????. ?? ???? ??? ????? ??? ??? ?????? ?????? INDEX ?? ?????? A1 ???? ?????? ?????? ?? ??????.

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

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

  1. ?????? ???? ????? ?? Excel 2003 ??? ??????? ????? ?? Excel? ???? ??? ???? ???? ??????? ?? ???? ??????? ?????? ?? ?? ??? ??? ?????? ???? ????? ???? ??????? ?? B2 ??? B6 ?? ???????? ????? ????? ??? ??? ??????.

    ??????? ???? ????? ?? Excel 2007? ???? ??? ????? ????? ??????? ????? ??? ?????? ?? ???? ??? ???? ??????? ?? ????? ????? ???? ???????.
  2. ???? ??? ?????? ?????? ??? ???? ???????? ?? ???? ??? ????? ???? ????. ???? ????????? ???????? ?? ???? ??? ?????:
    1. ?? ?????? ?????? ???????? ???? ?.

      ???? ??? ???? ??????? ??? ???? ?????? INDEX ??? ??? ???? ?? ???????.
    2. ?? ?????? ?????? ??????? ???? ?.

      ???? ??? ?????? ??? ???? ?? ???? ???? ??????? ??? ?????? ????? ?? ???????.
    3. ?? ?????? ?????? ??????? ???? ??. ???? ??? ????? ???? ?????? ???? ????????? ?? ???????.
    4. ?? ?????? ??????? ????????? ???? ?.

      ????? ??? ?????? ?? ??? ??????? ???? ??? ??????? ?????? ??????? ?????? ???? ???? ???? ???????.
    5. ?? ?????? ????? ??????? ???? ?. ????? ??? ?????? ?? ????? ????? ?????? ??????? ?? ???? ????? ???? ???? ??????? ??? ?? ?? ????? ???? ???????.
    6. ?????? ???? ????? ?? ?????? G1 (????? ?????? ???? ?? ?????? ?? ???????)? ???? G1 ?? ?????? ?????? ??????.

      ?????? ???? ???????? ????? ????? ??????? ?? ???? ???????? ???? ?????? ????? ??????? ??? ???? ???????.
???? ??? ??? ???? ??? ?? ??? ????? ???? ???????. ??? ????? ??? ???? ?????? ????? ?? ???? ?????? ????? ??? ???? ???????? ??? ????? ?????? G1 ??? ??? ???? ??? ?????? ??????? ????? ??????? ???? ?? ???? ???? ??????? ???????? ????? ???????. ???? ??????? ??? ????? ?? ?????? INDEX ?? ?????? A1 ???? ?????? ?????? ?? ?????? ?????? ??????.

??? ????? ????? ??? ???? ??????? ?????? ?????? ?? ????? ?? ???? ??????? ??? ?? ?? ????? ????? ??????? ?????? ?????? ??? ? (???? ????? ??????). ?? ????? ???? ??????? ??? ???? ?????? ??????? ? ???? ?????? ??? ???? ?????? ?????? ?? ??? ???? ?????? ??????? ?? ???? ?????? ??? ???? ?????? ?????.
?????? ??? ????? ?? ????? "????? ??????" ?? ??????? ??????? ?? ???? ????? ????? ?????? ?? Microsoft. ??? ????? ????????? ??????? ??? ????????? ???????? ???????. ??????? ????????? ?? ????? ??? ???????? ??? ????? ?????? ??????? ??? ??? ??? ??????? ???????? ??? ??? ???????? ?? ?? ??? ???? ????? ????. ???? ???? ????????? ?????? ?????????? ??????.

???????

???? ???????: 291073 - ????? ??? ??????: 03/?? ?????/1433 - ??????: 1.0
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2001 ?? Macintosh
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 98 ?? Macintosh
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 2010
????? ??????: 
kbexpertisebeginner kbhowto kbforms KB291073

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

 

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