Excel function MATCH

The MATCH function returns the position of a value in an array.

  • In the "Lookup_value" field, enter the value whose position you would like to return.
  • In the "Lookup_array" field, enter the data range within which the function is to search for the position of the "Lookup_value".
  • In the "Match_type" field, enter 0 to find the exact value, 1 for the highest value that is less than or equal to the "Lookup_value", -1 for the lowest value that is greater than or equal to the "Lookup_value".

match function - match

Result:

match - match