Thread: Find and Append Based on External List

result_file.xlsx

file1.xlsx

file2.xlsx

file1.xlsx - represents the file1
file2.xlsx - represents the file2
result_file.xlsx - represents file2 after the operations have completed.

Two files:

File1: (csv format)

item,description
A,special A text
B,special B text
C,special C text

File2: (.xls)

column1,column2,column3,column4,column5,column6,column7
data16,data17,data18,text7 D text8,data19,data20,null
data11,data12,data13,text5 C text6,data14,data15,null
data1,data2,data3,text1 A text2,data4,data5,null
data6,data7,data8,text3 B text4,data9,data10,null
data21,data22,data23,text8 E text9,data24,data25,null

This is what I'm trying to do.

IF "A" is found in "File2" then I want to append the "special A text" from File1into column7 on the same row where "A" is found, in the "null" cell
If "B" is found in "File2" then I want to append the "special B text" into column7 on the same row where "B" is found, in the "null" cell
.... and so on

Please note that in "File2", the interesting text that I am looking for "A", "B", or "C" is just a unique string that is inside of a cell that contains other strings of data that are of no interest. Here, they're denoted as "text1", "text2", etc.

I hope that I explained the problem well enough.

If necessary, the contents of "File1" can be added to another sheet inside the workbook of "File2"

Thanks for your assistance.

You forgot to post the example files...