The Problem The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. The Syntax is as below: MATCH(lookup_value, lookup_array, [match_type]) The match_type is an optional argument that can take one of three values; 0 Returns an exact match -1 returns the lowest … More A more versatile Match function for Excel