How To Use Match In Excel

Use the MATCH function in Excel to find the position of a specific value within a range or array.

Excel is a powerful tool that offers a wide range of functions to help individuals and businesses organize, analyze, and manipulate data effectively. One such function that proves to be exceptionally useful is the MATCH function. Whether you are a beginner or an experienced user of Excel, understanding how to use the MATCH function can provide you with the ability to quickly locate and retrieve information within a dataset. In this blog post, we will explore the ins and outs of using the MATCH function in Excel, along with practical examples to help you grasp its full potential. So, let’s dive in and uncover the secrets of leveraging the MATCH function in Excel to streamline your data analysis tasks.

How To Use Match In Excel: Step-by-Step


Step 1: Open Excel

To begin, launch Microsoft Excel on your computer. Whether you have existing data or need to create new data, open the desired document to start working efficiently.

Next Step

Step 2: Identify the Cell to Find Your Match

After determining where you want to display the matched value in your spreadsheet, simply click on the desired cell to highlight it as the destination for the matched value.

Next Step

Step 3: Enter the MATCH Formula

In the selected cell, type the formula =MATCH(). Excel will prompt you to enter three arguments for the MATCH function, which helps identify the position of a specific value within a specified range.

Next Step

Step 4: Input Lookup Value

The first argument in a lookup function is the lookup value, which is the piece of data you want to find within a specific range. You need to input the lookup value inside the parentheses, followed by a comma. For example, “=VLOOKUP(A1, B1:C10, 2, FALSE)”.

Next Step

Step 5: Define Lookup Array

This step is crucial to specify the specific range of cells or an array in which Excel should perform the search for the desired lookup value. Simply select the desired cells, and add another comma after selection.

Next Step

Step 6: Determine Match Type

The last argument in the function determines the type of match. Use 0 for an exact match, 1 for a partial match, and -1 for an approximate match. Close the parentheses after specifying the match type.

Next Step

Step 7: Press Enter

Once you have entered the required information into the formula and pressed Enter in Excel, it will provide you with the relative position of the lookup value within the array. If there is no matching value, an error will be displayed.

Next Step

Step 8: Interpret the Result

The number displayed after pressing enter indicates the relative position of your lookup value within the array, such as 5 meaning the lookup value is found at the 5th position in the specified range.


In this blog post, we have explored the amazing capabilities of the MATCH function in Excel. We have learned how to use this powerful tool to search for specific values in a range and retrieve their corresponding positions. Whether it’s finding the closest match, searching for duplicates, or performing advanced lookups, the MATCH function has proven to be an indispensable asset for data analysis and manipulation. By understanding the syntax and various options available, you can unleash the full potential of this function and make your spreadsheet tasks more efficient and precise. So go ahead, give it a try, and take your Excel skills to the next level with MATCH!

Table of Contents