Search for text and copy [Closed]


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?