Lookup Function

Returns a value from a row or column, range or from an array.
Returns a value from a row or column, range or from an array.

Rational

Lookup a row or column of a table.

Description

The LOOKUP function in Google Sheets search in a single row or column (search_range) for a given value (search_key) and return value from the same position or, next row or column [result_range].

Syntax

=LOOKUP(search_key, search_range,|search_result_array, [result_range])

Parameters

Search_key– value to find.

Search_range/search_result_array– a single row or column containing the search_keyThe value must be in ascending order.
result_range [optional] – the corresponding value of search_range from 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 the convenient function as it does not require search_range and result_range to be in the same table(unlike VLOOKUP).
  • The area of search_range data must be identical to result_range 
  • LOOKUP function is not case sensitive.