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

Match - Intro

HELPFUL RESOURCE:

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

SUMIFS Function: Introduction   What does it do? Sums multiple criteria Formula breakdown: =SUMIFS(Sum_Range,Criteria_Range1,Criteria1,Criteria_Range2,Criteria2...) What it means: =SUMIFS(Return the Sum from this Range,Evaluate this Range,With this Criteria,Evaluate that Range,With t...
SUMIF Function: One Criteria & Sum Range The SUMIF function can also be used to apply the criteria to one range and sum the corresponding values in a different range. So if you have a list of Sales Reps in one list and their Sales in another list and want to Sum the sales of only one of the Sales Reps, then the SUMIF...
Advanced SUMPRODUCT Function: Maximum Sales What makes the SUMPRODUCT function even more powerful is its ability to nest formulas, or in simple terms, add another function within the SUMPRODUCT function. Instead of getting the Total Sales for a region, we can extract the Maximum sales value simply by entering the MAX fu...
Sumproduct & Weighted Averages   What does it do? It returns the sum of the products of corresponding ranges or arrays Formula breakdown: =SUMPRODUCT(array1, , ...) What it means: =SUMPRODUCT(this array, with that array…) A quick way to calculate the weighted average of two lis...