How to Use MATCH Function | Microsoft Excel

How to Use MATCH Function | Microsoft Excel

how to use match function in excel


MATCH function is a lesser known function. Match function will return a position of the specific value given by you from a row and a column.

Syntax of MATCH Function

=MATCH(lookup_value,lookup_array,[match_type])

Arguments For MATCH Function

lookup_value: it is a value which you want to match in lookup_array
lookup_array: it is an array in which lookup_value is search
match_type: value is -1,0 and 1. How lookup_value searched in lookupo_array. the default value is 1

Match Type Description
-1 Describes: Match function finds the smallest value which is greater than or equal to the lookup_value
0 Describes: Match function finds the value which is exactly equal to lookup_value
1 Describes: Match function finds the largest value which is lesser or equal to the lookup_value

Behavior of MATCH Function

how to use match function

Here I want to know the position of March month
So I used the formula
=MATCH(“March”,B4:B9,)
March:  the value we want to know the position
B4:B9: Range of the data
After using this formula result we get is “3” because March is in the 3rd position in the data

Usage of MATCH Function

To know the position of the given value

Returnof MATCH Function

The position of the value

Note
You can not select more than one column for the data

Error Values of MATCH Function

Error CommandsDescription
#NALookup_value is not available in the range
If you select more than one column or row for a data range

Leave a Reply

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