## Excel Match Function

Image 01 |

In this image, we can see that this is a table which contains Column A “Product” and in Column B “Count” and in Column C there is a product name from the product list “Apples”. The use of Match Function is to find the position of “Apples” in the list and in this list, the position of “Apples” is “3”.

## Syntax

**MATCH(lookup_value, lookup_array, [match_type])**

The MATCH function syntax has the following arguments:

**lookup_value** – The value to match in lookup_array.

**lookup_array** – The range of cells being searched.

**match_type** – Optional. The number -1, 0 or 1. The** match_type** argument specifies how Excel matches **lookup_value **with values in **lookup_array**. The default value for this argument is 1.

If **Match_type** is 1, [**Match** finds the largest value that is less than or equal to lookup_value and it requires sorting the **lookup_array** in ascending order, i.e. from small to large or from A to Z.]

**Match_type**is 0, [

**Match**finds the first value exactly equal to

**lookup_value**and the

**lookup_array**argument can be in any order.]

**match_type**is -1 [Match finds the smallest value that is greater than or equal to

**lookup_value**. The

**lookup_array**must be sorted in descending order.]

**Match**returns the position of the matched value within**lookup_array**.**Match**returns the #N/A error if no match is found.**A match**is not case-sensitive.

**lookup_array**contains several occurrences of the

**lookup_value**, the position of the first value will be returned.

Image 02 |

In the above image, we put all three kind of formula (1,0,-1)

**match_type**“1” because it will return a position of nearest and below of value “35” and the position is 2nd, i.e. below “35”, “34” is the nearest and below “35” value. So the result is “2”

**match_type**“0”, and it gives us position of “34” is 2nd. So the result is “2”.

**match_type**(-1) the result is #N/A, The reason is #N/A is because as per the rule if the match_type “-1” then we have to sort the range in the form of descending order, so once we descending the Column B then see what will be position of “52”

Image 03 |

## Match Function with Vlookup

Image 04 |

Let’s understand a new image :-

Image 05 |

Image 06 |

**Vlookup and Match,**we can see the formula bar the formula is loaded by “Match Function”. We have seen that there is no change in the result. It is same as we get by the single Vlookup.

Image 07 |

**Unit Price**from the list A1: E 1, and it does not matter that how many column we add or delete. The formula will produce the result accurately without any cell or column change or change in result.