Questions tagged [excel-match]

Definition:

MATCH is a Microsoft Excel function which searches for the lookup_value from the lookup_array (a range of cells) based on the match_type.

It returns the relative position of the first matched value in the given range, and if no match is found, it returns #N/A.

Syntax:

MATCH(lookup_value, lookup_array, [match_type])

Where:

• lookup_value (Required) - The value to search and match in the given array.
• lookup_array (Required) - The array or range of cells to search for the given value.
• match_type (Optional) - The type of match to perform on the given array. 1 is the default value. There are three possible values:
  • 1 - To find the position of largest value that is less than or equal to the lookup_value. The lookup_array must be sorted in ascending order.
  • 0 - To find the position of the first value that is equal to the lookup_value. The lookup_array can be in any order.
  • -1 - To find the position of the smallest value that is greater than or equal to the lookup_value. The lookup_array must be sorted in descending order.

Learn More:

• MATCH function (Microsoft Office Support)