Excel need to match and paste to an adjacent cell : <p>So the formula needs to look at column D IN SHEET 1, go over to sheet 2, if it finds a match in column A, then paste the coordinates in column B into sheet 1 column E.<a href="http://i.stack.imgur.com/rehLP.png" rel="nofollow">IMAGE</a></p>
