MATCH Function - Excel
Overview
The MATCH function in Excel is a useful tool to search for a specified value in a range and return the relative position or rank of that item within the range. This function helps us locate the position of a particular value within a specified set of data.
Example:
=MATCH("Cart", C2: C6)
Syntax:
=MATCH(lookup_value, lookup_array, [match_type])
lookup_value: The value you want to find within the lookup_array.
lookup_array: The range of cells containing the data.
[match_type]: An optional argument specifying the type of match. It can be 1 (less than), 0 (exact match), or -1 (greater than). If omitted, it defaults to 1.
Example
In the example above, the MATCH function is looking at the range in C2:C6 and looking for the position where “Cart” is located. The final output is 4 because it is the 4th word on the list and we are not counting the column title on C1 in the range.