Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/LOOKUP
(view source)
Revision as of 23:07, 13 February 2014
No change in size
,
23:07, 13 February 2014
→LOOKUP(lkup_val, lkup_vector, rslt_vector)
Line 1:
Line 1:
=LOOKUP(lkup_val, lkup_vector, rslt_vector)=
=LOOKUP(lkup_val, lkup_vector, rslt_vector)=
−
*
where, '''lkup_val''' is the value to be matched from an array or range of values,
+
where,
+
*
'''lkup_val''' is the value to be matched from an array or range of values,
*'''lkup_vector''' is the array of values or reference to one-row or one-column containing values, and
*'''lkup_vector''' is the array of values or reference to one-row or one-column containing values, and
*'''rslt_vector''' is a range that contains only one-row or one-column and is same size as lkup_vector.
*'''rslt_vector''' is a range that contains only one-row or one-column and is same size as lkup_vector.
Swapna
writer
2,661
edits