Manuals/calci/HLOOKUP

From ZCubes Wiki
Revision as of 21:36, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"><font face="Arial, sans-serif"><font size="2">'''HLOOKUP'''</font></font><font face="Arial, sans-serif"><font size="2">(l...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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