MATCH Function Explained
The MATCH function in Microsoft Excel is used to look up a value in an array and return its relative position. It takes three arguments: lookup_value, lookup_array, and match_type. The lookup_value is the value to be found in the array. The lookup_array is the range of cells to be searched. The match_type is an optional argument that specifies whether the function should find an exact match or an approximate match. If the match_type is omitted, the function will default to an exact match. The MATCH function returns the relative position of the lookup_value in the lookup_array.
MATCH Function Syntax
MATCH(lookup_value, lookup_array, [match_type])
- lookup_value: The value to search for in the lookup_array.
- lookup_array: The range of cells to search for the lookup_value.
- match_type: (optional) A number that specifies how Excel matches lookup_value with values in lookup_array. The default value is 1.