Discover how to use LOOKUP function in a formula.
When to use
The array form of LOOKUP looks in the first row or column of an array for the specified value and returns a value from the same position in the last row or column of the same array.
- The syntax for LOOKUP is as follows:
- Lookup_value is the value that LOOKUP searches for in an array. The Lookup_value argument can be a number, text, a logical value, or a name or reference that refers to a value
- Array is the range of cells that contains text, numbers, or logical values that you want to compare with Lookup_value.
- Lookup_value is the value that LOOKUP searches for in an array. In the example above the Lookup_value is ‘G19’
- Array is the range of cells that contains text, numbers, or logical values that you want to compare with Lookup_value – the Array is G12:K12
- In this example the formula contains one more argument, which makes the formula more stable. Further, the Lookup_vector and the Result_vector do not need to be in the same worksheet or even the same workbook. In fact, as long as there are the same number of elements in each, one can be a row vector and the other a column vector. The Result_vector is coming from cells G13:K13
- LOOKUP is very useful when the Lookup_vector contains data in strict ascending order. Which is found in Dates in time series – LOOKUP is very useful for financial modelling / forecasting.
Lesson notes are only available for subscribers.