Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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:

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 »
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 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 »
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 »
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 »