HomeApplicationOffice information

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

  • FIND function in Excel - Usage and examplesFIND function in Excel - Usage and examples
    find function in excel - usage and examples. the find function in excel is a function of the text function group, you can use the find function to find the position of a substring of text in another text. to understand more about the find function, how to use it and the examples used in the find function
  • VLOOKUP function to use and specific examplesVLOOKUP function to use and specific examples
    vlookup is one of the most useful excel functions but few understand it. in this article, we will help you understand vlookup with practical examples, such as grading students and staff using the vlookup function.
  • ROUNDUP function in Excel - Usage and examplesROUNDUP function in Excel - Usage and examples
    today, the software tips will guide you how to use the roundup function to round numbers (rounding up) in excel. roundup function structure function syntax: = roundup (number, num_digits). in which: + roundup: is the function name. + number: is the number to be rounded up. + num_digits: is the number of digits after the comma you want to round. for example:
  • DSUM function in Excel, how to use DSUM function and examplesDSUM function in Excel, how to use DSUM function and examples
    dsum function in excel, how to use dsum function and examples. the dsum function in excel is a fairly common function with a fairly simple usage. but if you do not know how to use the dsum function, you can refer to the following article to understand h
  • How to use the MAXA function in Excel, detailed examplesHow to use the MAXA function in Excel, detailed examples
    the maxa function in excel helps find the largest value in a data set, including numbers, logical values, and text containing numbers. this is different from the max function, which only counts numbers. let's learn the syntax and usage of the maxa function with practical examples.
  • RANK function - Rank function in Excel - Usage and examplesRANK function - Rank function in Excel - Usage and examples
    the rank function arranges equal numbers of the same rank. however, the duplication will affect the ranking of subsequent numbers. for example, you have the sequence number: 1,2,2,3,4 and are arranged in ascending order, so the order of the number 1 in the series is 5.
  • DCount function in Excel - How to use the DCount function and examples using the DCount functionDCount function in Excel - How to use the DCount function and examples using the DCount function
    dcount function in excel - how to use the dcount function and examples using the dcount function you have a large list of students who want to get a high total score, but don't want to spend a lot of time. in this article, introduce to you the dcount function in excel. help c
  • The search function satisfies many conditions in Excel - Usage and examplesThe search function satisfies many conditions in Excel - Usage and examples
    the search function satisfies many conditions in excel - usage and examples. in the process of processing data in excel many times you need to search for data that satisfies many conditions to extract data, so you are looking for a function that satisfies many things.
  • INDIRECT function in Excel - How to use INDIRECT function and examples using INDIRECT functionINDIRECT function in Excel - How to use INDIRECT function and examples using INDIRECT function
    indirect function in excel - how to use indirect function and examples using indirect function. you want to refer to a range of data without changing the formula in the cell. the following article introduces you to the indirect function in excel to help you reference
  • Multiple if function - Usage and examplesMultiple if function - Usage and examples
    the following article gives you a detailed guide on how to use the multiple if function with examples. the if function is simplified in the sense that the function tests a value with a given condition, if it satisfies the condition that returns 1 value, if it does not satisfy the condition.

Office information