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?

Ruth,

Try this in X3 on sheet 2

=IF(Sheet1!A3=Sheet2!A3,Sheet1!G3,"")

Drag down as required

Mike

"Ruth0276" wrote:

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?

Thanks for that...it works for some of the cells, but in some cases the A's
on Sheet 1 aren't the same as the A's on Sheet 2 so it leaves a blank.

Is there anyway that if it isn't the same on both sheets it can search for
the same numbers in the rest of column A on sheet 1 or 2?

Sorry for all the questions

"Mike H" wrote:

Ruth,

Try this in X3 on sheet 2

=IF(Sheet1!A3=Sheet2!A3,Sheet1!G3,"")

Drag down as required

Mike

"Ruth0276" wrote:

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?