Pinterest Pixel

MATCH Function Intro

John Michaloudis
 .

 

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

Download excel workbookMatch-Intro.xlsx

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 Function Intro

 

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 Function Intro

Lookup_array

Where is the list that contains the stock items?

=MATCH(G13, C12:C16,

MATCH Function Intro

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 Function Intro

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

MATCH Function Intro

How to Use the Match Formula in Excel

 

If you like this Excel tip, please share it


Founder & Chief Inspirational Officer

at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  SUMIF Function: One Criteria & Sum Range

Steps To Follow

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...