With two ranges of equal size, is there a way to easily reference the cell of one that is in the same relative position as in another?

  • I'm looping through all the cells in a range and want to get the value of the cell in the same position in another range that's the same size when the cell value in the first range equals a certain value and insert it into another cell. I can't quite figure how to do this. Here's where I am