how to keep only the exact names of my list and delete the rest VBA macro excel

Hello

I have this script which work for my column A.

Please Login or Register  to view this content.

However i wanted to apply the same script for my excel file for column B i just changed by

Please Login or Register  to view this content.

, So is that i'd like delete now all components that are not in the list looking in my two columns A and B .
For column A, it worked. i only have components that are part of my list however when i wanted to applied to column B it didn't work. I'd also like to keep only components that contain exactly the same word and not just part of the word. For example if in my list i have "methane" i'd like to keep only all components containing this exact word and not "sulfinysbismethane".



Before applying the macro i have this
TEST 6.PNG


So basically i have in my list "chloro", "2,2,5-trimethylhexane" 2,2,4-trimethylpentante","water" and at the end i'd like to have this.

test 7.PNG

As you can see from the 3 pairs i'd like keep only "2,2,5-trimethylhexane" 2,2,4-trimethylpentante" as they are both on the list. Also for each component i'd like to keep its UTI and Reference as showed in the picture 2.

I hope i was clear. Thank you for your help. Please find attached the excel file

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

See Forum Rule #5 about thread duplication.

https://www.excelforum.com/excel-pro...cro-excel.html