HomeApplicationOffice informationMATCH function in Excel, usage and examples

MATCH function in Excel, usage and examples

In this article, we will learn the syntax, usage and illustrative examples to effectively apply the MATCH function in work.

INSTRUCTIONS FOR USING MATCH FUNCTION IN EXCEL

Syntax: MATCH(Lookup_value,Lookup_array,[Match_type])

In there:

- Lookup_value : The value to look up, which can be a number, text, logical value, or a cell reference to a number, text, or logical value, required
- Lookup_array : The array to look up, required
- Match_type : The type of search. Optional.

Getting familiar with how to number in Excel quickly is also necessary, helping you work with Excel quickly, giving more accurate results. You can refer to TipsMake's article to learn how to number easily.

There are 3 types of searches:

1:Less than (Smaller than search value)
0: Exact match (Exact search value)
-1:Greater than (Greater than search value)

When omitted, the MATCH function defaults to 1.

Example : Given a list of a group of students, find the class order of each student in the table below:

MATCH function in Excel, usage and examples Picture 1

The formula in cell E5 is : =MATCH(D5,$D$9:$D$11,0)

We have the result:

MATCH function in Excel, usage and examples Picture 2

With a fairly simple syntax and usage, the MATCH function in Excel helps you search for an item in a list and returns the relative position of that item. This function is especially useful when you need to determine the location of data in a table, supporting quick information lookup.

To improve the lookup efficiency, you can combine the MATCH function with the INDEX function, which helps to get data by row or column based on the found position. This is a popular way to create dynamic lookup formulas in Excel, helping you to handle data more accurately and flexibly.

4 ★ | 1 Vote
excel

You should read it

May be interested

  • Detailed instructions for mail merge in Word 2010, 2013, 2016Photo of Detailed instructions for mail merge in Word 2010, 2013, 2016
    mail merge in word helps users create a series of invitations, announcements, or personalized documents without having to enter each information manually. this feature is especially useful when drafting administrative documents, surveys, or contracts.
  • PRODUCT function in Excel, syntax, usagePhoto of PRODUCT function in Excel, syntax, usage
    the product function in excel helps to quickly calculate the product of multiple values, instead of having to enter each number with a multiplication sign. this function is useful in calculating financial, scientific and accounting data.
  • GAMMAINV function in Excel, how to use and examplesPhoto of GAMMAINV function in Excel, how to use and examples
    the gammainv function in excel helps calculate the inverse value of the cumulative gamma distribution, which is used in statistics and data analysis. this article will guide you on how to use the gammainv function with specific illustrative examples.
  • How to use the IF function in ExcelPhoto of How to use the IF function in Excel
    the if function in excel helps you easily check conditions and return corresponding results, providing optimal support in calculating and processing data. this is one of the important functions, widely used to automate the comparison and classification of information.
  • Count function in excel, formula, how to use count function in most detailPhoto of Count function in excel, formula, how to use count function in most detail
    in excel, the count function is a powerful tool that helps you quickly count numeric values ​​in a spreadsheet. whether you are new or familiar with excel, mastering the syntax and usage will make calculations easier. let's explore the details in the article below.
  • How to type with 10 fingers using Typing TrainerPhoto of How to type with 10 fingers using Typing Trainer
    if you want to practice typing with 10 fingers and improve your typing skills, typing trainer is a great choice. try it out and test your typing speed with the useful features of the software.

Office information