I want to link 2 workbooks together by saying something along the lines of ..

If Cell A3 in sheet one is the same as A3 in sheet 2 place the contents of
G3 in sheet one into X3 in Sheet 2

And want the formula to be able to use all the data in the A,G and X
columns (600+ cells)

Is this possible?