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