I need a formula to tell me if items in column C are new compared to Column A. I tried attaching a worksheet, but it will not open up to copy in worksheet. I basically will have a list of items that are current in column A. In column C I will have a list of new items added. I need a formula that will compare the two list and tell me that it is a new item. I do not want to use conditional formatting. Here is an example. In column D I would like for it to tell me if the items in Column C are the same, or New Item. I need a formula that I can drag down. Thanks,

Column A Column C Column D
Banana Banana
Apples Apples
Carrots Carrots
Peanuts Cucumber New Item
Peanuts