Now that we’ve gotten familiar with both the exact ‘MATCH’ and one of the inexact ‘MATCH’ scenarios, let’s take a look at a scenario in which the inexact ‘MATCH’ using the ‘match_type’ of 1 may be useful.
Consider a case where we would like to set a sales amount cutoff again, but this time we want to find the position in the list that is equal to or the first number below the cutoff.
Let’s use March sales this time and choose our cutoff sales value to be $15,000.
Practically speaking, this will give us the position where all sales numbers below that are definitively less than our cutoff figure.
First things first: We have to sort our March sales column smallest to largest or ascending in order for the ‘MATCH’ function to work.
Then we set or formula to be ‘=MATCH(A23,D9:D12,1)’.
Our result is ‘2’ which means every sales value above and including the second position in the list is less than $15,000.
Reviewing our table closer we find that this amount matches ‘Wayne Mayes’ in the ‘Salesperson’ column.