Match Function

Match function is very useful to identify the location of a required cell in a ROW or COLUMN. This function don't return value. it returns only cell(lookup) cell postion. This function alone is not useful for user. If we combined this function with V-Lookup or Index .. some other functions it is very useful

Syntax of Match Function:

Lookup_Value

Lookup value represents to value that we need to find

Lookup_Array

It is a range of continuous cells, which consists of ROW or COLUMN
It must represensts to a single ROW or COLUMN

Match_Type

0 = exact match. Lookup array can be in any order

1 or Omitted = Closet value which is less than or equal to lookup value. Values in lookup_array must be arranged in ascending order

-1 = Closet value which is less than or equal to lookup value. Values in lookup_array must be arranged in DESCENDING order

Example:

Download The Workbook