The MATCH function searches a range of cells for a specified item and returns its relative position within the range. If the values 5, 25, and 38 are in the range A1:A3, the formula =MATCH(25,A1:A3,0) produces the number 2, because 25 is the second item in the range.