Partial Match - domains to email addresses

Copper Contributor

I have two columns, column A with domain names (around 500), column B with email addresses (around 5000) - how can I identify email addresses that contain the domains? 

 

For example, if my list of domains is: 

yahoo.com

nike.com

adidas.com

 

I need to identify email addresses that contain: @yahoo.com, @nike.com / @adidas.com 

 

Thank you! 

 

2 Replies

@supermajda 

I suggest conditional formatting to identify all email addresses for a certain domain. I entered data validation for all domains (3 in this example) in A1 and chose "adidas.com" and all email addresses containing "@adidas.com" in column B are highlighted.

I entered this formula (rule) for conditional formatting;

=COUNT(FIND("@"&$A$1,B1))

and in the manager for conditional formatting, in the field "applies to" i entered:

=$B$1:$B$1000

This can be adjusted to the requirements.

Thank you so much for your time and advice! @OliverScheurich

I am not super familiar with data validation either, would you mind attaching your spreadsheet?
I am testing out your formulas as we speak.

Thanks again!