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**

**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*

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

###
*Return**of 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 Commands | Description |

#NA | Lookup_value is not available in the range If you select more than one column or row for a data range |

## No comments:

## Post a Comment