How to use MATCH Function (Formula) in Excel

MATCH

Use of Match Function / Formula in Excel :

Returns the relative position of an item in an array that matches a specified value in a specified order.

Syntax / Formula of MATCH Function in Excel:

The Syntax of MATCH function in Microsoft Excel is below

=MATCH(lookup_value, lookup_array, [match_type])

Example of MATCH Function in Excel:

In below example we need Rahul position in student list

Step 1: First created below table in your excel starting from position C1:F11, and Type student name  in cell A1 for Ex. Rahul.

Step 2: Type formula =MATCH(A1,E2:E11,0) in cell A2 and press enter.

             In this formula A1 (Rahul) is lookup_value, E2:E11 (Student list) is lookup_array and 0 is Exact match. 

MATCH FUNCTION