Search for a word in a cell

[Cakin]

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

[Cakin]

Maybe this is confusing?

I'd Like to search an entire column using a name cell on another sheet then have something to tell me it was found in that column or it wasn't.

[Haseeb Avarakkan]

B2, copy down.

=IF(ISNA(MATCH("*"&A2&"*",'Change Log'!E:E,0)),"Not Found","Found")

If A2 contains somewhere in 'Change Log!E:E, this will show 'Found' otherwise 'Not Found'.