Excel MATCH Function

Excel MATCH Function
© Ted French

The MATCH function, one of Excel's lookup functions, can be used to find the exact position of data in an Excel database or list.

For example, MATCH can be used to find how well a specific stock is performing in a list of investments or how well a student is doing relative to the class as a whole.

MATCH can also be combined with other functions, such as INDEX, to make more complex and versatile lookup formulas.

To find out all the details on how this function works, read this short tutorial on the Excel MATCH Function.

• Excel VLOOKUP Step by Step Tutorial
• Excel Two Way Lookup Formula
• Excel HLOOKUP Step by Step Tutorial