????? ??????? VLOOKUP ?? HLOOKUP ?????? ??? ????? ???

?????? ????????? ?????? ?????????
???? ???????: 181213 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

????? ???????? VLOOKUP ?HLOOKUP ??? ????? ???? range_lookup ????? ???? ?? ??????? ?????? ??? ????? ??? ????? ????? ??? ??? ???? ?????.

?????? ?? ???? ??? ???? ????? ??? ??? ?????? ??????? range_lookup ????? ????.

??????? ????

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

???? VLOOKUP

   =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
				
???:
   ???????     ????? ???????
   ---------------------------------------------------------------------

   lookup_value ?????? ???????? ?? ?????? ????? ?? ??????.

   table_array ???? ????????? ???? ??? ????? ??? ?? ??????.

   col_index    ??? ?????? ?? table_array ???? ???
                ????? ?????? ???????? ????.

   range_lookup ?? ?????? ???????? ????? ???? ?? ???
                ??? ???? ?? ?????? ??? ????? ??? ?? ????? ??????.
                ??? ???? ??? ?????? TRUE ?? ???? ?????? ??? ????? ????? ??????? 
                ????? ???? ??? ?? ??? ?????? ??? ????? ???? ???
                ????? ???? ???? ????? ????? ???? ??? ?? lookup_value
                . ??? ???? ?????? ?? FALSE? ???? ?????? VLOOKUP ??? ????? ???. ??? ?? ???
                ?????? ??? ????? ???? ??? ????? ???? ????? #N/A.
				
?????? ??? ???? ?????? ???????? range_lookup ?? TRUE ?? ???? ????? (?????? ??????)? ???? ?? ??? ??? ????? ???????? ?? ?????? ????? ?? table_array ?????? ??????. ??? ??? ???? ?????? ???????? range_lookup ?? FALSE (?????? ???)? ?? ???? ??? table_array.

???? ?????? ?????? FALSE ?????? Range_lookup

????? ??????? ??????? ??? ??? ??????? ???????? ?????? ???. ???? ??? ?? ??? ??? ?????? ?????:
   A1: ???????    B1: ?????    
   A2: ??????     B2: ????  
   A3: ?????   B3: ????  
   A4: ?????    B4: ???????    
   A5: ??????    B5: ????      
				
???? ?????? ??????? ??? ????? (????) ???? ?????? ?? ????? "??????". ????? ????? ?????? ?? ?? ???? ?? ???? ?????:
=VLOOKUP("Apple",A2:B5,2,FALSE)
				
???? ??? ??? ??? ?????? ????? range_lookup ??? TRUE? ????? Excel ?????? ????? #N/A? ???? ??? ??? ?????? ?????.

???? HLOOKUP

=HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)
				
???:
   ???????     ????? ???????
   ---------------------------------------------------------------------

   lookup_value ?????? ???????? ?? ?????? ????? ?? ??????.

   table_array ???? ????????? ???? ??? ????? ??? ?? ??????.

   row_index    ??? ???? ?? table_array ???? ???
                ????? ?????? ???????? ????.

   range_lookup ?? ?????? ???????? ????? ???? ?? ???
                ??? ???? ?? ?????? ??? ????? ??? ?? ????? ??????.
                ??? ???? ??? ?????? TRUE ?? ???? ?????? ??? ????? ????? ??????? 
                ????? ???? ??? ?? ??? ?????? ??? ????? ???? ???
                ????? ???? ???? ????? ????? ???? ??? ?? lookup_value
                . ??? ???? ?????? ?? FALSE? ???? ?????? VLOOKUP ??? ????? ???.
                ??? ?? ??? ?????? ??? ????? ???? ??? ????? ???? ????? #N/A
                .
				
?????? ??? ???? ?????? ???????? range_lookup ?? TRUE ?? ???? ????? (?????? ??????)? ???? ?? ??? ??? ????? ???????? ?? ???? ????? ?? table_array ?????? ??????. ??? ??? ???? ?????? ???????? range_lookup ?? FALSE (?????? ???)? ?? ???? ??? table_array.

???? ?????? ?????? FALSE ?????? Range_lookup

????? ??????? ??????? ??? ??? ??????? ???????? ?????? ???. ???? ??? ?? ??? ??? ?????? ?????:
   A1: ???????    B1: ?????
   A2: ??????     B2: ????
   A3: ?????   B3: ????
   A4: ?????    B4: ???????
   A5: ??????    B5: ????
				
???? ?????? ??????? ??? ?????? "?????"? ????? ?????? ?????? ?????? (-?) ??????? "????". ????? ????? ?????? ?? ?? ???? ?? ???? ?????:
=HLOOKUP("Color",A1:B5,3,FALSE)
				
???? ??? ??? ??? ?????? ????? range_lookup ??? TRUE? ????? Excel ?????? ????? #N/A? ???? ??? ??? ?????? ?????.

?????

?????? ??? ??????? ?????? ??? ????? ??????? ????? LOOKUP ?? Microsoft Excel? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft" (?? ????? ??? ???????? ??? ???????? ??? ????? ?????? ?????????? (????? ?? ??? ?????? ???)):
181212 XL: ??????? ??? ??? ?????? ??? ?????? ?? Excel
214264 XL: ????? ????? ??? ???? ???? ??????
214069 XL: ????? ????? ??? ?? ??? ????? ?? ????
181201 XL: ????? HLOOKUP ?VLOOKUP ?LOOKUP ???? ??? ?????
213476 XL: ????? ??? ?????? ????? ??? ???? ?? ?? ?????? ?? ???? ?????
280094 XL: ???? ????? ?????? ?? ??? ???????? ?????? ????? ??????
????? ?? ????????? ??? ???? HLOOKUP? ???? ??? ??????? Microsoft Excel ?? ??????? ???????? ?? ???? ???? ???? ??? HLOOKUP ?? "????? Office" ?? ?? "????? ???????"? ?? ???? ??? ??? ???? ???????.
????? ?? ????????? ??? ???? VLOOKUP? ???? ??? ??????? Microsoft Excel ?? ??????? ???????? ?? ???? ???? ???? ??? VLOOKUP ?? "????? Office" ?? ?? "????? ???????"? ?? ???? ??? ??? ???? ???????.
?????? ??? ????? ?? ????? "????? ??????" ?? ??????? ??????? ?? ???? ????? ????? ?????? ?? Microsoft. ??? ????? ????????? ??????? ??? ????????? ???????? ???????. ??????? ????????? ?? ????? ??? ???????? ??? ????? ?????? ??????? ??? ??? ??? ??????? ???????? ??? ??? ???????? ?? ?? ??? ???? ????? ????. ???? ???? ????????? ?????? ?????????? ??????.

???????

???? ???????: 181213 - ????? ??? ??????: 18/???? ??????/1434 - ??????: 1.0
????? ???
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Office Excel 2003
  • Microsoft Excel 2010
  • Microsoft Office Excel 2007
????? ??????: 
kbhowto KB181213

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

 

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