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:
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.
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.
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.
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.
