Excel formula to find row number hit appears on

Excel formula to find row number hit appears on

January 31, 2020

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. 

 

 

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

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