Excel MATCH function

Function              MATCH

Description        Excel MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.

Syntax  MATCH(lookup_value, lookup_array, [match_type])

lookup_value  The value to be matched in lookup_array.

lookup_array  is a range of cells or an array reference.

match_type – [optional] Type of match, specified as 1 (Less Than), 0 (Exact Match), or -1 (Greater than). Default is 1

Related Video Tutorials: