MATCH

The MATCH formula is used to search for a value within a range of cells and return the relative position of the value within the range. To use the MATCH formula, select the cell where you want the result to appear and enter “=MATCH(” followed by the value you want to search for and the range of cells you want to search in. For example, “=MATCH(A1,A2:A5,0)” would search for the value in cell A1 within cells A2 through A5, and return the position of the value within the range.

Example:

Search for the value in cell A1 within cells A2 through A5, and return the position of the value within the range: =MATCH(A1,A2:A5,0).