Manuals/calci/LOOKUP

Syntax

Examples

''''''' ''''

Description

LOOKUP

LOOKUP(lkup_val,lkup_vec,res_vec)

where lkup_val is a value that LOOKUP searches for in the first vector,

lkup_vec is a range that contains only one row or one column and

res_vec is a range that contains only one row or column.

LOOKUP gives a value either from a one-row or one-column range or from an [javascript:AppendPopup(this,'xldefArray_1') array].

[javascript:ToggleDiv('divExpCollAsst_1') Let's see an example in C1R1 : C2R5]

[javascript:ToggleDiv('divExpCollAsst_1') C1 C2]

[javascript:ToggleDiv('divExpCollAsst_1') R1 10 Apple]

[javascript:ToggleDiv('divExpCollAsst_1') R2 20 Orange]

[javascript:ToggleDiv('divExpCollAsst_1') R3 30 Lemon]

[javascript:ToggleDiv('divExpCollAsst_1') R4 40 Pear]

[javascript:ToggleDiv('divExpCollAsst_1') R5 50 Guava]

I.e. =LOOKUP(30,C1R1:C1R5,C2R1:C2R5) is lemon