The function MATCH 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,range to look from,match_type)
Lookup_value: is the value you are looking for in the range, can be a number, text, or logical value, or a reference to one of these.
Range too look from: is a contiguous range of cells containing possible lookup values, a list of values, or a reference to a range.
Match_type: is a number 1, 0, or -1 indicating which value to return.