Excel MATCH Function Generator

Find the position of a value within a range.

The value you want to find. Can be a specific value (e.g., 42) or a cell reference (e.g., A1).
The range of cells in which to search for the lookup_value (e.g., B1:B10).
• 0: Finds an exact match.
• 1: Finds the closest match ≤ lookup_value (requires sorted data in ascending order).
• -1: Finds the closest match ≥ lookup_value (requires sorted data in descending order).
Generated Formula:

Examples of MATCH Function

Scenario Formula Result
Find 50 in a list of numbers =MATCH(50, {10, 20, 50, 80, 100}, 0) 3
Find "Mango" in a list of fruits =MATCH("Mango", {"Cherry","Mango","Apple"}, 0) 2
Find 40 in the list that does not exist =MATCH(40, {5,10,15,20,25}, 0) #N/A
Search the smallest value greater than or equal to 75 =MATCH(75, {100, 80, 50, 20, 10}, -1) 2
Find a word in a column (case-insensitive) =MATCH("Mango", B2:B10, 0)
Find the position of 5 in a sorted list using approximate match =MATCH(5, {1, 3, 5, 7, 9}, 1) 3