LOOKUP (vector) function
The vector syntax form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range. A vector is a range of only one row or one column. Use this form of the LOOKUP function when you want to specify the range that contains the values you want to match.
A value that LOOKUP searches for in the first vector. The argument lookup_value can be a number, text, a logical value, or a name or reference that refers to a value.
A range that contains only one row or one column. The values in lookup_vector can be text, numbers, or logical values.
The values in this argument must be put in ascending order: ...,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, this function may not give the correct value. Uppercase and lowercase text are equivalent.
A range that contains only one row or column. It must be the same size as lookup_vector.
To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.