skip to Main Content

# How to use Excel MATCH function

## SUMMARY INFO

All the basic information regarding MATCH function in Excel is listed in the table below. (This data is regularly updated from Microsoft and several resources)

 Function: MATCH Function Category: Lookup and reference Description: Looks up values in a reference or array Return Value: A number representing a position in lookup_array. Syntax: =MATCH (lookup_value, lookup_array, [match_type]) Applies to: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 Other languages: English: MATCH French: EQUIV German: VERGLEICH Spanish: COINCIDIR Dutch: VERGELIJKEN Italian: CONFRONTA Russian: ПОИСКПОЗ Danish: SAMMENLIGN Swedish: PASSA Portuguese (Brazil): CORRESP Polish: PODAJ.POZYCJĘ Finnish: VASTINE Norwegian: SAMMENLIGNE Portuguese (Portugal): CORRESP Czech: POZVYHLEDAT Hungarian: HOL.VAN Turkish: KAÇINCI All Other Languages: MATCH Related Functions: INDEX, VLOOKUP

## FUNCTION DETAILS

Syntax details of Excel Match Formula with an example regarding the correct usage of function can be seen below.

### =MATCH (lookup_value, lookup_array, [match_type])

lookup_value The value to match in lookup_array.
lookup_array  A range of cells or an array reference.
match_type [optional] How to match, specified as -1, 0, or 1. Default is 1.

## VIDEO EXAMPLES

Check the video below to see How to use MATCH in Excel with some examples:

## LINKS AND RESOURCES

Here we provide a list of useful links which we think can be useful while trying to learn the function usage with some examples and tips.

Microsoft Office support page – Excel MATCH formula:
https://support.office.com/en-us/article/MATCH-function-e8dffd45-c762-47d6-bf89-533f4a37673a

INDEX & MATCH functions in Excel – a better alternative to VLOOKUP:
https://www.ablebits.com/office-addins-blog/2014/08/13/excel-index-match-function-vlookup/

## EXCEL FORMULAS TRAINER

As said: Practice Makes Perfect!

Test your Excel skills in Excel itself with our unique product: Excel Formulas Trainer.

30 sections and around 100 questions with full hands-on experience. Progress tracking, dashboard, error checking and many more. Check it now: