|What do you mean by unmatched items?|
Do you have items in C that are not in D and items that in D but not in C and you want them all extracted?
Do have a list in C with "extra" items in D and you want the extra items extracted?
Please provide some more details and maybe even a sample of your data with the expected output.
Before posting any data, click on the following line and read the instruction found via that link.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.