MATCH formula looks for an item within a range and returns the relative position of that item in the range. It is used in combination of the INDEX function.
