Building a macro to look into another datasheet

[WT2008]

I have two excel files:

products.xls
keywords.xls

products.xls:
column C: Is the list of colors for each product
column D: I want put the narrowed names resulting from the match when I run the macro.
keywords.xls
column A: Is a list of color names
column B: Is the narrowed name I assigned for each color name on column A.

Example: I assigned “red” as the narrowed name for the color names Light Red, Dark Red and Fire Red.
I want put in column D (file products.xls) Red if in the column C (file products.xls) exist Light Red, Dark Red or Fire Red. I don’t want repeat the word “red” in Column D, even if there are more than one match per row.

Actual match: if we take row 4, column C (file products.xls), the list is:
Black, Dark Green, Navy Blue, NG Black, NG Dk Green, Dark Blue, Light Blue, Royal Blue.

I want, in the D (file products.xls):

Black, Green, Blue

Can anyone help me on this please. Thank you in advance.




products.xls keywords.xls

[WT2008]

Any help here? – Perhaps any tip about where something similar comes up!

[Kevin UK]

Why not post in the relevant forum, might get some response

http://www.excelforum.com/excel-programming-vba-macros/

[arlu1201]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

In future if you need to move a thread to the relevant subforum, do not create a new thread, instead PM a moderator to move the thread for you. This will prevent duplicate threads.

Thread Closed.