TOP
ǹ [ Լ] ã/ Լ HLOOKUP









HLOOKUP Լ

 

 

̺ ù ࿡ ִ Ǵ 迭 ˻


̺ Ǵ 迭  κ

 

ִ ȯմϴ.

 

 

 

 

 

 

 


 

  





: =HLOOKUP(lookup_valuetable_arrayrow_index_num, range_lookup)

 

 

Lookup_value - table_array ù ° ࿡ ϵ


ڰ ã ϴ ˻ ,

 

ã ϹǷ մϴ.


, , Ǵ ڿ ֽϴ.
 

Table_array - ˻Ϸ ͵ Ե ,


Ͽ  Ͱ ִ ,

 

մϴ.


ϴ ˴ϴ.


table_array ù ࿡

 

lookup_value ϴ Էµ˴ϴ. 

 

Row_index_num - table_array ù ° ࿡


lookup_value ϵ  ã

 

ϴ Ͱ ԵǾ ִ ȣ մϴ.

 

, ޱ ̹Ƿ 1, 2 ǹǷ


, ִ 2 Էϸ

 

͸ ֽϴ.

 

, row_index_num ڰ

1 ۰ų table_array ü  ũ

#VALUE!, #REF! Ÿϴ.

 Range_lookup - Ȯϰ ġϴ ã


false Ǵ ϰ,

 

ٻ簪 ã true Էմϴ.


true Ȱ˴ϴ.


  

  

 

(0)
Copyright (c) 2000-2025 by bizforms.co.kr All rights reserved.
 1588-8443. 9:30~12:30, 13:30~17:30 ȭ㿹 û
ȭ Ŭ
ŬƮ