Manuals/calci/LOOKUP
Syntax
Examples
Description
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
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 10 | Apple | ||
| Row2 | 20 | Orange | ||
| Row3 | 30 | Lemon | ||
| Row4 | 40 | Pear | ||
| Row5 | 50 | Guava | ||
| Row6 | Lemon | |||
| Row7 | ||||
| Row8 |
