Manuals/calci/HLOOKUP
Jump to navigation
Jump to search
HLOOKUP(lk_val,tb_arr,rw_index_num,range_lk)
where lk_val is the value to be found in the first row of the table ,
tb_arr is a table of information in which data is looked up,
rw_index is the row number in tb_arr from which the matching value will be returned and
range_lk is a logical value that specifies whether one wants HLOOKUP to find an exact match or an approximate match.
It searches for a value in the top row of a table or an [javascript:AppendPopup(this,'xldefArray_1') array ]of values.
HLOOKUP
Let's see an example
C1 C2 C3
R1 Orange Apple Lemon
R2 6 10 5
R3 4 3 9
R4 8 7 12
=HLOOKUP(“Orange”,C1R1:C3R4,2,TRUE) is 5
///rly =HLOOKUP(“Apple”,C1R1:C3R4,3,FALSE) is 3
Syntax
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | Orange | apple | Lemon | |
Row2 | 6 | 10 | 5 | |
Row3 | 4 | 3 | 9 | |
Row4 | 8 | 7 | 12 | |
Row5 | 5 | |||
Row6 | 3 |