LOOKUP

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.

CHOOSE

The CHOOSE function returns specific information from a list of data points, =CHOOSE(4,”Railways”,”Roads”,”Airways”,”Waterways”) returns Waterways.

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.

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

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.