LOOKUP

Lookup a row or column of a table in Excel
Returns a value either from a one-row or one-column range or from an array

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:

Lookup a value in the top row of a table or an array in Excel

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.

Read More »
Lookup a value in a left column of a table or an array in Excel

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.

Read More »
Returns value from a data as per given offset range in Excel

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.

Read More »
Returns the relative cell position of value

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

Read More »
Returns a specific position from a list in Excel

CHOOSE

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

Read More »