Search

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.

=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.


5 views

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com