Excel formula to find row number hit appears on

You can use the Excel MATCH formula to find the row number of that a value in a range appears in.


The MATCH formula searches for where the value in cell F2 appears in column A and then the ROW formula returns the row number that value appears on.