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.

DOWNLOAD EXCEL WORKBOOK

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(

Match Formula

 

STEP 2: The MATCH arguments:

Lookup_value

What is the value that we want to match?

We want to match the Tablet.

=MATCH(G13,

Match Formula

Lookup_array

Where is the list that contains the stock items?

=MATCH(G13, C12:C16,

Match Formula

Match_type

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

 

HELPFUL RESOURCE:

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

3

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin