Rational
Lookup a row or column of a table.
Description
The Excel LOOKUP function search in single row or column (lookup_vector) for a given value (lookup_value) and return value from same position or, next row or column [result_vector].
Syntax
=LOOKUP(lookup_value, lookup_vector, [result_vector])
Parameters
lookup_value – value to find.
lookup_vector – a single row or column containing the lookup_value. The value must be in ascending order.
result_vector [optional] – thecorresponding value of lookup_vectorfrom a single row or column range.
Return Value
Corresponding value
Key Notes
- The LOOKUP function may return an erroneous result if the first column of data is not arranged in ascending order.
- The LOOKUP can be convenient function as it does not require lookup_vector and result_vector to be in the same table (unlike VLOOKUP).
- The area of lookup_vector data must be identical to result_vector data.
- LOOKUP function is not case sensitive.
Keep Reading Similar Functions:
HLOOKUP
The HLOOKUP function extract data in a horizontal pattern which means heading in 1st row and value begins from 2nd row, and retrieve data from left to right.
VLOOKUP
The VLOOKUP function extract data in a vertical pattern which means heading in 1st column and value begins from the 2nd column and retrieve data from left to right.
OFFSET
The OFFSET function returns one or multiple data points of a data set by giving a reference point with a specified number of rows and columns to offset.
MATCH
The MATCH function finds row or column of a given value containing in a data set, cell B3 in a list contains ‘Feb’ =MATCH(B3,B1:B10,0) returns 2 (3rd row).
CHOOSE
The CHOOSE function returns specific information from a list of data points, =CHOOSE(4,”Railways”,”Roads”,”Airways”,”Waterways”) returns Waterways.