How to Use MATCH Function in Excel

The MATCH function in excel just returns the index of first appearance of a value in an array (single dimension). This function is mostly associated with INDEX function, often known as INDEX-MATCH function.

Let’s understand the aspects of MATCH function.
1
Syntax of MATCH Function:

=MATCH(lookup value, lookup array, match type)

lookup value: The value you are looking for in the array.
lookup array: The arrays in which you are looking for a value
Match Type: The match type. 0 for an exact match, 1 for less than and -1 for greater than.

Example.
2
In the above image, we have a table. In cell H1, we have our task returning Index number of first appearance of Gill and Kivell.

In cell I2, write this formula and drag it down to I3.

=MATCH(H2,$C$2:$C$15,0)

We have our index numbers.
3
Now you can use this index number with INDEX function of excel to retrieve data from tables.

If you don’t know how to use INDEX MATCH function to retrieve data, below article will be helpful for you.

Retrieving Matching Values from not adjacent List

Do you know how to use MATCH formula with VLOOKUP to automate reports? In Next article we will learn use of VLOOKUP MATCH formula. Till then, Keep Practicing – Keep Excelling.

Articles other readers visit:

Excel VLOOKUP Function

Use INDEX-MATCH instead of VLOOKUP

Excel INDEX Function

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube