LOOKUP()
Syntax
(Vector Version). LOOKUP(lookup_value,lookup_vector,result_vector)
(Array Version). LOOKUP(lookup_value,array)
Definition. This function finds values in an array (a cell range or an array constant). If the array consists of only one column or row, the vector version is used.
The vector version looks for a value in a vector and returns the value at the same position in the second vector.
The array version looks for a value in the first row or column of an array and returns the value at the same position in the last row or column of the same array.
Arguments (Vector Version)
lookup_value (required). Must evaluate to a number, string, or logical value. This argument can be a reference to a cell containing the value.
lookup_vector (required) ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
