Excel Match

 Excel MATCH function searches for a value in an array and returns the relative position of that item.

Match function in excel is used to searches for the value of item in an array and returns the relative position of that Item. 

Syntax of the match function
 "MATCH(Value looking For , Lookup Array, Match type)

Value Looking For :- The value that you want to find in the list of data. It  be a number, text, logical value, or a cell reference .

Lookup Array
 :-The range of cells need to be  searched

Match type for exact match is "0".

Example:-


Excel Match




If we want find the position of Vinoy in the list ,we can use Match function.




It is a very useful Function in Excel.

No comments:

Post a Comment