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: