????? ??????? ????? ???? ????? INDEX ? MATCH ?? ?????? ?????? ?? Excel

?????? ????????? ?????? ?????????
???? ???????: 214142 - ??? ???????? ???? ????? ????? ??? ???????.
?????? ??? Microsoft Excel 98 ???????? ?????? ?? ??? ???????? ???? 59482.
????? ???? | ?? ????

?? ??? ??????

??????

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

??????? ????

?????? ??????? ??????? ?? ???? ????? INDEX ? MATCH ????? ????? ???? ???????? ??? ??? ??????.

???? 1: ???????? ?? ???????

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

  1. ??? ????? Excel.
  2. ???? ???????? ??????? ?? ???? ??? ?????:
       A1: Part   B1:  Code   C1:  Price   D1:  Find Part  E1:  Find Code
       A2: x      B2:  11     C2:  5.00    D2:  y          E2:  12
       A3: x      B3:  12     C3:  6.00    D3:  y          E3:  11
       A4: y      B4:  11     C4:  7.00    D4:  x          E4:  12
       A5: y      B5:  12     C5:  8.00    D5:  x          E5:  11
    					
  3. ??????? ????? y ??? ???? 12 ??????? ???? ?????? F2? ???? ?????? ??????? ?? ?????? F2:
    =INDEX($C$2:$C$5,MATCH(D2,IF($B$2:$B$5=E2,$A$2:$A$5),0))
  4. ???? CTRL + SHIFT + ENTER ?????? ?????? ????? ??????.

    ???? ?????? ???? 8.00.
  5. ??? ?????? F2 ??????? ???? ??????? ?? ????? ????? ??? ?????? F5 ???????? ????? ??? ?????? ??? ????????? ????????.

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

???? ??? ????? ???? ???? ?????? ????? ????? ?? ???. ?? ???? ????? ?????? ??????? ???? ??????? ???????? ?? ???? ?? ??????? ????? ?? ????? ?????? IF ?????????. ???? ????? ????? "??????? ??????" ??? ?? ????? ???????? ?????? ???????? ?? ?????? 3 ???????? ?????? ???????:
=INDEX($C$2:$C$5,MATCH(D2&E2,$A$2:$A$5&$B$2:$B$5,0))

???? 2: ???????? ????? ?? ????

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

  1. ??? ????? Excel.
  2. ???? ???????? ??????? ?? ???? ??? ?????:
       A1: Part        B1: x      C1: x     D1: y       E1: y
       A2: Code        B2: 11     C2: 12    D2: 11      E2: 12
       A3: Price       B3: 5.00   C3: 6.00  D3: 7.00    E3: 8.00
       A4: Find Part   B4: y      C4: y     D4: x       E4: x
       A5: Find Code   B5: 12     C5: 11    D5: 12      E5: 11
    					
  3. ??????? ????? y ??? ???? 12 ??????? ?????? ?? ?????? B6? ???? ?????? ??????? ?? ?????? B6:
    =INDEX($B$3:$E$3,MATCH(B4,IF($B$2:$E$2=B5,$B$1:$E$1),0))
  4. ???? CTRL + SHIFT + ENTER ?????? ?????? ????? ??????.

    ???? ?????? ???? 8.00.
  5. ??? ?????? B6 ??????? ???? ??????? ?? ????? ??? ?????? ??? ?????? E6 ???????? ????? ??? ?????? ??? ????????? ????????.

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

???? ??? ????? ???? ???? ?????? ????? ????? ?? ???. ?? ???? ????? ?????? ??????? ???? ??????? ???????? ?? ???? ?? ??????? ????? ?? ????? ?????? IF ?????????. ???? ????? ????? "??????? ??????" (??? ?????? 2) ??? ??? ????? ??????? ?????? ?? ?????? 3 ???????? ?????? ???????:
=INDEX($B$3:$E$3,MATCH(B4&B5,$B$1:$E$1&$B$2:$E$2,0))

???????

???? ???????: 214142 - ????? ??? ??????: 09/???? ?????/1433 - ??????: 1.0
????? ???
  • Microsoft Office Excel 2003
  • Microsoft Office Excel 2007
  • Microsoft Excel 2010
????? ??????: 
kbquery kbfunctions kbhowto kbmt KB214142 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????214142

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

 

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