XL: ??????? ????? ????? ??????? Microsoft Excel (Lookup.xla)

?????? ????????? ?????? ?????????
???? ???????: 147255 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

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

??????? ???????? ?? ??? ??????? ?? ????? "??? ??" ???? ??? ???? Microsoft ?? ???? ???????? ?? ???? ???????. ??? ????? ?? ?? ????? ?????? ????? ?????? ?? Microsoft ?? ??????? ???????? ???????? ??? ??????? ???????? "? ?? ?????? ?????? ??????? ???????? ??? ????? ????? ?????.

??????: "????? ?????" ??????? ?? Microsoft Excel 97 ?? ??????? Microsoft Excel 98 ????????.

??????? ????

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

?????? 1 ?? ?????

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

??? ???? ??????? ???????? Microsoft Excel ???? ??? ???? ?????? ????? ???? "????? ??????". ?? ????? Microsoft Excel (??????? 5.0 ?????????? ??????) ?????? ??? ???? ??????? ?????? ??. ??? ??? ?????? ?? ????? ???? ????, ??? ???? ????? ?????? ?????? ???????? ?????? ?? ?? ???? ??????? ??????.

??????: ?? ????? ?? ?????? ?????? ???????? ?? ???? ???????? ??????. ?????? ??????? ??? ???????? ?? ??????? ???????.

?????? 2 ?? ?????

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

??? ??????? ?????? ????? ("????? ?? ????? ?????? ??????" ? "?? ????? ??? ?? ????? ?????? ??????") ?? ??? ????????? ?????? ???? ?????. Microsoft Excel ?????? ???? ???? ?? ?? ??????? ??? ?? ?? ????? ??? ?????? ???????. ??? ?? ????? ???? ????? ????? ???? ? ??? ?????? ????? ?????? ?????? ????. ??????? ??????? ??? ?? ????? ???? ????? ?????? ???? "? ??? ?????? ????? ?????? ????? ????. ??? ????? ?????? ???? ????? ??????? ?????? ???????? ???? ??????? ???????:
??? ???? ?????? ???? ????? ??? ????? ???????? ??????. ???? ?? ???? ?????? ???????? ????? ?? ?? ????? ????. ?????? ???????? ??? ????.

?????? 3 ?? ?????

?? ??? ??????? ???? ??????? ???? ?????? ??? ???? ?????. ???? ??????? ???????? ?? ???? ??????? ???? ?????? ??? ???? ?????. ?????? ?? ?? ???????? ???????:

  • ??? ???? ????? ???? ?? ??????? ?? ????????? ??????? ???. (?? ??? ?????? ??? ??? ???? ?????.)

    ???? ??? ?????? ???? ?????? ??? ???? ????? ?? ?????? ???? ???????.
  • ????? ?????? ????? ??????? ?? ???? ?????? ???? ?????? ???? ????? ??????. (?? ??? ???? ??????? ?????.)

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

?????? 4 ?? ?????

???????? ??? ?????? ???? ??? ???????? ?? ?????? 3 ?? ???????? ????????? ??????? ?? ??? ????????? ??????. ???????? ??? ?????? ???? ??? ???????? ??? ??? ????????? ????????:

  • ??? ????? ?????? ????? ?? ?????? 3 (??? ??? ???? ????? ???? ?? ??????? ?? ????????? ??????? ???) ? ????? ??? ????? ???? ?????? ??? ?????? ???. ????? ??????? ?????? ?????? ???? ?????? ?? ????? ?????? ??.
  • ??? ????? ?????? ?????? ?? ?????? 3 (??? ????? ?????? ????? ??????? ?? ???? ?????) ? ????? ??? ????? ???? ?????? ??? ???? ??? ??????? ????? ? ?????? ???. ??? ????? ???? ???? ????? ??? ??? ??????? ?????? ???? ?????? ??????? ???????? ??? ??????? ???????? ?? ??? ????. (??????? ?????? ????? ??????? 3.) ????? ????? ?????? ???????? ?????? ?? ????? ????? ?? ???? ??????.

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

??????: ??? ?? ????? ?? ??????? ??? ??????, ??? ???? ????? ??????? ????????. ?????? ????? ????? ?? ???? ????? Readme.txt ?????? ??? ??????? ???????. ?? Microsoft Excel 97 ? ??????? Microsoft Excel 98 ???????? ? ???? ??? ????? ?????? ??? ??????? ????? "????" ????? ????? ".

??????? ???????? ??? ???????? ?? ??? ??????? ???? ?????? ??? ????? ??????? Microsoft TechNet ??? Online Services.

?????? ??? ??????? ?????? ??? ????? ??? ?? Online Services ?????? ?????? ??????? ??????? ?? "????? ??????? ?? Microsoft:
119591????? ?????? ??? ????? ??? Microsoft ?? ??????? ??? ????????


???????? "????? ?????" ? ??? ???:

  1. ???? ?? ??? ??? ???? ?????? ????:
           A1:           B1: Comp A   C1: Comp B   D1: Comp C   E1: Comp D
           A2: 8/1/95    B2: 99.45    C2: 70       D2: 43.5     E2: 92
           A3: 8/3/95    B3: 100      C3: 50.5     D3: 44       E3: 90.12
           A4: 8/5/95    B4: 103.5    C4: 53.25    D4: 43       E4: 91.5
           A5: 8/7/95    B5: 102.12   C5: 55       D5: 43.12    E5: 93.5
           A6: 8/9/95    B6: 101.5    C6: 53.25    D6: 43.75    E6: 95.75
           A7: 8/11/95   B7: 100.75   C7: 50.2     D7: 44.12    E7: 95.12
           A8: 8/13/95   B8: 101.25   C8: 48.75    D8: 44.5     E8: 93.25
           A9: 8/15/95   B9: 101.75   C9: 48       D9: 44.12    E9: 94
          A10: 8/17/95  B10: 100.25  C10: 50      D10: 43.75   E10: 94.5
  2. ?? ??????? ?????? ???? ??? "????? ?????". (??? ???? ??? ??????? ????? ? ??? ??? ????? ? ?? ???? ??? ???.)
  3. ?? ?????? 1 ???????? $ ???? A $ 1: $ E $ 10 ??? ?? ???? ???????. ??? ?? ???, ???? ?? ?????? ??????. ???? ??? "??????".
  4. ?? ?????? 2 ?? ???????? ??? ????? ?????? "C Comp" ????? ???? "8/11/95" ?? ???????. ???? ??? "??????".
  5. ?? ?????? 3 ?? ???????? ??? "??? ?????? ??? ?? ???? ?????." ???? ??? "??????".
  6. ?? ?????? 4 ?? ???????? ???? ???? ?????? ?? ???? ????? ???? ?????? ??? $ F $ 1. ???? ??? ???? "?????". ????? ???????? ?? F1 44.12 ????? ?????? ???????:
          =INDEX($A$1:$E$10,MATCH(DATEVALUE("8/11/95"),$A$1:$A$10,),
             MATCH("Comp C",$A$1:$E$1,))

???????

???? ???????: 147255 - ????? ??? ??????: 12/???/1426 - ??????: 1.3
????? ???
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 98 ?? Macintosh
????? ??????: 
kbmt kbhowto KB147255 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????147255
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

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

 

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