Search

Lookup Range

Last Updated: Mar 15, 2021

Articles

Use this function to check if a value exists in the specified range and returns the address of the cell where the value exists.

Syntax

Lookup Range (search_range, lookup_value, occurrence)

Parameters

Input Parameter Name Description
search_range First cell to last cell value separated by : to search the value
lookup_value The value to be searched
occurrence Occurrence of the value

Returns

Return value Description
Position Returns the position of the cell

Sample

Lookup Range (C3:F8, key, 2)

  • Checks for the 2nd occurrence of the value key in the range C3 to F8.
    Returns the address C5.

To view all the Excel functions, click here.

Did you find what you were looking for?