I read the comments above, and basically had to lay it out just like the original question said, then tried both answers. The first answer didn't work for me; I must have been doing something wrong, or not smart enough. Then tried the second answer, and believe I had to modify just the cells to match what I wanted. I had 2,566 cells I had to match up in two different columns. So here's the formula I used for the first three lines, then copy/pasted and dragged down to paste in all 2,566 cells to match up:
When you paste that formula in a cell, and slowly click on each of the sections within the parenthesis, it shows you what cells are highlighted. So by doing that, I was able to see which cells it's looking at, and it made more sense to me. So then I just highlighted the whole column, or picked the appropriate cell, and it worked. Then all I had to do was copy/paste the formula to the next line down and next line down, then paste it all the way down through my document, and it automatically converted to the correct cells.
Hope this helps.