*'''OtherArray''' is a range that contains only one-row or one-column and is same size as lkup_vector.
*'''OtherArray''' is a range that contains only one-row or one-column and is same size as lkup_vector.
−
LOOKUP() looks up for a specified value in one-row range or one-column range or an array, and displays a value from same position in second one-row range or one-column range or an array.