How to use Excel Match Formulas

Click her e to download the Excel Workbook which contains below example

Match Function: Excel Match function will help to lookup a particular value/text within lookup_array. In result, it will give the position number of lookup value/text value in the selected array. Position can be Column or Row.

Below Quick snapshot of Excel Match Formula

Syntax of Excel Match Formula

MATCH(lookup_value,lookup_array,[match_type])

First Argument: lookup_value this is a compulsory argument
Second Argument: lookup_array this is a compulsory argument
Third Argument:[match_type] this is a optional argument

Explanation of Arguments in Excel Match Formula

lookup_value: This is a compulsory argument, here we need to select the lookup value for which we want the match and get the position number.

lookup_array: This is a compulsory argument, here we need to select the range to check and match value we have updated in the first argument. The counting of Row and Columns numbers will be started as per the look_up array.

Examples of Match_Type (3rd Argument)

Match_type: This is an optional argument, you can leave it blank. If you leave blank the default value for this argument is 1 (Less than).

0 Exact Match: Finds the Exact value which is equal to lookup_value. It is advisable to use Exact match_type if you are not sure to use which option.