writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − *where, '''lkup_val''' is the value to be matched from an array or range of values,+ +
→LOOKUP(lkup_val, lkup_vector, rslt_vector)
=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,
*'''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.