How to use MATCH to find approximate matches

Let’s take a look.

I’ll start off entering the MATCH formula in C6.

The match value comes from column B, and the lookup_array is “sales”.

Now we need to specify the match_type.

0 is only for exact matches, so we have two options: 1 and -1.

In this case, the values are in ascending order, so we want a match_type of 1.

When I copy the function down,MATCHreturns the position of the match found in the Sales list.

you might see why it’s important that the list be sorted in ascending order.

There are a few more things to notice here.

We’ll do that next when we combine theMATCH functionwith theINDEX function.