Excel Function-Match

 Excel Function:Match

This DataWitzz tutorial will explain you about MATCH function of excel.Let us first start with the functionality MATCH,it searches for a value in an array and returns the relative position of that value.
It is built-in function of excel and will come under lookup/reference category.

Syntax:=Match(lookup value,array in which we want to find the position,[Match_Type])

Match_Type is optional and three values can be used as mentioned below:

  

Example-1:

Note:

1. MATCH function is not a case sensitive function.
2. If MATCH function doesn't find any match it will return #n/a error.
3. We can use WILD CARD when Match_Type is 0 and Lookup value is text.
   
       

Example-2:

Example-3:

  

You can read more about match function from the below link.

https://datawitzz.com/how-to-use-match-function-in-excel/

I am  sharing my YouTube video for Match function which explains it in very elaboration way.

 

 You also can download the working file from the link: