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

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

?? ????? ??

??????

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

???? ???????

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

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

?????? 1

  1. Excel ??????? ????.
  2. ?? ?? ?????????? ??? ????? ???? ?????:
       A1: ???   B1:  ???   C1:  ?????   D1:  ??? ????  E1:  ??? ????
       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. ??? 12 ?? ??? ??? y ?? ????? ??????? ???? ?? ??? ?? ???? 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 ??? ???? ??? ????.

?????? 2

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

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

?????? 1

  1. Excel ??????? ????.
  2. ?? ?? ?????????? ??? ????? ???? ?????:
       A1: ???   B1: x      C1: x     D1: y       E1: y
       A2: ???   B2: 11     C2: 12    D2: 11      E2: 12
       A3: ?????       B3: 5.00     C3: 6.00    D3: 7.00    E3: 8.00
       A4: ??? ????  B4: y      C4: y     D4: x       E4: x
       A5: ??? ????   B5: 12     C5: 11    D5: 12      E5: 11
    					
  3. ??? 12 ?? ??? ??? y ?? ????? ??????? ???? ?? ??? ?? ???? 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 ?? ???? ??? ????.

?????? 2

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

???

???? ID: 214142 - ????? ???????: 03 ??????? 2013 - ??????: 4.0
???? ???? ???? ??:
  • Microsoft Office Excel 2003
  • Microsoft Office Excel 2007
  • Microsoft Excel 2010
??????: 
kbquery kbfunctions kbhowto KB214142

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

 

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