????? ??????? ???? INDEX ????? ?? ?????? ?? ???? Excel

?????? ????????? ?????? ?????????
???? ???????: 324988 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

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

???? ??????? ????? INDEX ? ???? ? ????. ????? ?????? ???????? ??? ????????? ??? ???:
  • ????? ?????? ?????? ???? ?? ???? ????? ?? ?? ???.????? ???? ????? ???? ?????? ??? ????? ??????????? ?????? ????????.
  • ???? ????? ?????? ??? ?????? ???????? CTRL + SHIFT + ENTER? ????? ?? ???? ????? ???????.

??????? ????

???? ???????? ??????? ?? ???? ??? Excel ?????. ???? ??????? ??? ???????? ?????? ?????? ?? ??? ???????.
?? ??? ??????????? ??? ??????
ABC
1???????????
2????50128
3????20119
4????10122
5???30129
6
7????40121
8??10123
9???30130

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

  1. ???? ?????? ??????? ?? ?????? E2 (?? ?? ???? ?????????????):
    =INDEX((A2:C5,A7:C9),2,3,2)
    (A2:C5? a7: c9) ?? ?????? ??? ???? ?????? ?? ?????? ???? ??????.

    2 ?? ??? ???? ?? ?????? ??? ???? ??????.

    3 ?? ??? ?????? ?? ???????? ???? ??????. ??????????? ????? ????? (????? ?? ?????? A)? ?????? ?????? ???????.

    2 ?? ???????? A2:C5 ?? a7: c9? ???? ??????. ????? ?????? ??????? ????? ??????? ???? ?????? isA7:C9.
  2. ???? ??????? ENTER.
?? ????? ?????? ???? INDEX ?????? ???? ??? ????? ???? ?????? (2) ??????? ?????? (C) ?? ?????? a7: c9. ?????? ?? ?????? C8 23. ?????? ????? ?????? =INDEX((A2:C5,A7:C9),2,3,2) ???? 23.

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

  1. ???? ?????? ??????? ?? ?????? E3 (?? ?? ???? ?????????????):
    =INDEX(A2:C5,2,3)
    A2:C5 ?????? ??? ???? ?????? ?? ?????? ???? ??????.

    2 ?? ??? ???? ?? ?????? ??? ???? ??????.

    3 ?? ??? ?????? ?? ?????? ??? ???? ??????. ??????????? ????? ????? (????? ?? ?????? A)? ?????? ?????? ???????.
  2. ???? CTRL + SHIFT + ENTER ?????? ?????? ???????????.
?? ????? ?????? ???? INDEX ?????? ???? ??? ????? ???? ?????? (2) ??????? ?????? (C). ?????? ?? ?????? C2 19. ?????? ????? ?????? =INDEX(A2:C5,2,3) ???? 19.

???????

???? ???????: 324988 - ????? ??? ??????: 02/????? ??????/1435 - ??????: 5.0
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Office Excel 2003
  • Microsoft Excel 2010
????? ??????: 
kbhowto kbmt KB324988 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????324988

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

 

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