Reference
No results for 'undefined'
    Powered by Algolia

    MATCH

    Searches for a specified item in a range of cells, and then returns the relative position of that item in the range. For example, if the range A1:A3 contains the values 5, 25, and 38, then the formula =MATCH(25,A1:A3,0) returns the number 2, because 25 is the second item in the range.

    Syntax

    =MATCH(lookup_value, range, [match type])

    Parameters

    1. lookup_value
      • Type: Any
      • Description: Value to find
    2. range
      • Type: Frame
      • Description: Range to find values in
    3. match type [optional]
      • Type: Integer
      • Description: Match type. 1 or omitted - MATCH finds the largest value that is less than or equal to lookup_value. 0 - MATCH finds the first value that is exactly equal to lookup_value. -1 - MATCH finds the smallest value that is greater than or equal to lookup_value

    Returns

    • Type: Integer
    • Description: Returns the relative position of a specific value from the beginning of the range

    Example

    =MATCH(25,A1:A3,0)

    Notes

    MATCH function returns the position in a range of a matched values rather then the value itself. For example, if the range A1:A3 contains the values 5, 25, and 38, then the formula =MATCH(25,A1:A3,0) returns the number 2, because 25 is the second item in the range.
    Contents