Search for text and copy

puzzled - Jan 29, 2016 at 11:15 AM

I have two columns, A contains the list of a company and C contains emails. I would like to search the email column for emails containing partial characters from each company, find such email address and place it in column B, which is currently blank. Any thoughts?