Excel formula to find row number hit appears on
- Sean O'Shea
- Jan 31, 2020
- 1 min read
You can use the Excel MATCH formula to find the row number of that a value in a range appears in.
=MATCH(F2,A:A,0)+ROW(A:A)-1
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.
