Array form
The LOOKUP function looks for a value in the first row or column of an array and returns a corresponding value from the last row or column.
Syntax
LOOKUP(lookup_value, array)
Argument |
Description |
Permitted values |
|---|---|---|
lookup_value |
Value to be searched for in the “array” argument |
Any value |
array |
Range in which the value is searched for and from which the result is returned |
Range of cells or array of data |
Examples of use
Searching for a city by index in an array
=LOOKUP(125009, A2:B20)
The formula searches for index 125009 in the first column of the array A2:B20 and returns the city name from the last column.
Search for currency by country code
=LOOKUP("US", C1:F50)
The formula searches for the code “US” in the first row of the array C1:F50 and returns the currency name from the last row.
Notes
–If the lookup_value is not found, the closest smaller value is returned.
–The LOOKUP function works with sorted arrays. If the arrays are not sorted, the results may be unpredictable.
–To perform a search in unsorted data, use VLOOKUP, MATCH, or INDEX.