Excel Function : LOOKUP
Lookup and reference
Looks up values in a vector or array
Microsoft Excel Reference Page
Syntax and Description of the LOOKUP Excel Function
What is the syntax for the LOOKUP excel function?
LOOKUP(lookup_value, lookup_vector, [result_vector])
How do you specify which of the two syntaxes you want to use?
You use the first when you want to return values from a separate array based on the value in a separate array.
You use the second when you want to return values from an array or range of cells based on the value in the same array or range of cells.
About LOOKUP Excel Function
LOOKUP is an Excel function used to find values in a specific row or column. The syntax for the LOOKUP function is as follows: LOOKUP(value, array, [result_array]) value is the value you want to look up. array is the array of values you want to search. result_array is the array of values you want to return.