Search for a word in a cell

Hi,

I'm trying to true up a change log and wanted to make sure all the changes have been tracked. I did some compares in excel that gave me all the things that were added and deleted but now i need a way to find them inside my change log and then show me the text it was found in like a vlookup. so basically I'll have a event name like LLLDR3XX__0000000 and then in my other sheet there will be a cell that will say some like:
Added new OR events LLLDR3XX__0000000, LLLDR3XX__0000001, LLLDR3XX__0000002, LLLDR3XX__0000003, LLLDR3XX__0000004, LLLDR3XX__0000005, LLLDR3XX__0000006, LLLDR3XX__0000007, and LLLDR3XX__0000008.
The added or removed events will be in the "Details of Change" column (E) in the "Change Log" sheet in the example attached.

Any help would be appreciated, thanks