Manuals/calci/HLOOKUP

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