If the value in Z1 is found in A1, what are "the 2 cells prior to the
found cell from each other"?


In article ,
COBOL Dinosaur wrote:

How do I loop through a range of cells (A1:Y40) looking for a match to
another cell (Z1). There will be multiple matches.
When a match is found, I want to subtract the 2 cells prior to the found
cell from each other and accumulate all of the results.
THANK YOU!!
-John Smith