What does it do?

It returns the position of an item in a range

Formula breakdown:

=MATCH(lookup_value, lookup_array, [match_type])

What it means:

=MATCH(lookup this value, from this list or range of cells, return me the Exact Match)

The MATCH function in Excel returns the position of an item within a list or a range of cells.

Say that you have a Price List and want to know in which position a certain item is located within that Price List, then you would use the MATCH function.

NB: The lookup_value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value.

MATCH Function Intro | MyExcelOnline


We want to get the position within the Stock list where the Tablet is located.

STEP 1: Enter the following:

We need to enter the MATCH function in a blank cell:


Match Formula


STEP 2: The MATCH arguments:


What is the value that we want to match?

We want to match the Tablet.


Match Formula


Where is the list that contains the stock items?

=MATCH(G13, C12:C16,

Match Formula


What kind of matching do you want?

Let’s put in 0 to get the exact match

=MATCH(G13, C12:C16, 0)

Match Formula

And with that, you will get that tablet is in Row #3!

Match Formula

How to Use the Match Formula in Excel



How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

MATCH Function Intro | MyExcelOnline