I have a database list over 10,000 contacts that is organized by First Name, Last Name, Email Address and Company.

The last fields I need to sort and fill in are the Company field. Is there a formula I can use that can search the whole email column for multiple phrases like "@yahoo", or "@aig.com", or "@investmentfirm.com"? And then have it return a value in the company field that would show Yahoo, AIG, Investment Firm (respectively)? and if it there is an email that I haven't added in the conditional formula like "@fkdsjflkds.com" it just returns a blank response in the company field? PLEASE HELP!!!!!!!!