COPY TEXT FROM COLUMN G IN 1 WORKBOOK TO ANOTHER WORKBOOK IF CELL IN COLUMN IS SAME

[xenios]

Hi All!

If there is a change the following can be done.

Have 2 workbooks

1 has names in column A, and comments in Column G, H... in 1 workbook
Need to copy comments in column G, H... where text in column A is the same to another workbook ( or can be to another sheet if not possible in different workbook).

Attached example.
1 - initial file
2 - next file

Thank you!

 

[mrshl9898]

Thanks for that.

The basic formula is =IFERROR(IF(VLOOKUP(A4,'1'!A:G,7,0)=0,"",VLOOKUP(A4,'1'!A:G,7,0)),"")

But how do you tell what date the notes are from?

 

[Fluff]

As the formula is returning text values, you simplify that formula to

=IFNA(T(VLOOKUP(A4,'1'!A:G,7,0)),"")

 

[xenios]

As the formula is returning text values, you simplify that formula to

=IFNA(T(VLOOKUP(A4,'1'!A:G,7,0)),"")

Thanks for that.

The basic formula is =IFERROR(IF(VLOOKUP(A4,'1'!A:G,7,0)=0,"",VLOOKUP(A4,'1'!A:G,7,0)),"")

But how do you tell what date the notes are from?

Great, Thank you! The notes dates I put manually.

 

[xenios]

As the formula is returning text values, you simplify that formula to

=IFNA(T(VLOOKUP(A4,'1'!A:G,7,0)),"")

Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.