MATCH FUNCTION IN EXCEL

MATCH :- Match function it is use to find position in a list.

Note :- It is MATCH function is deliberate for one purpose, find the numeric position of an item in a list.

For example, we can use MATCH to get the position of the word “Pencil” in this list of Product Name like this:-

Syntax:-  =MATCH(lookup_value,lookup_array,{match type}(0/1) Enter

Example :- =MATCH("Pencil",F6:F12,0) Enter

Note:- 

MATCH Function doesn't care if the list is horizontal or vertical. If we arrange the list of product Name

 Horizontally, we get the same result with this MATCH formula:-

Syntax:-  =MATCH(lookup_value,lookup_array,{match type}(0/1) Enter

Example :-=MATCH("Pencil",G16:M16,0) Enter