The MATCH function provides the position number of the first occurrence of each item in a data range. In case of duplicate values, the MATCH function will only return the position of the first occurrence in the data range.