Need to figure out which email addresses in a list contain one of several domains

[jmb2019]

I have a list of 1,000 email addresses and a separate list of 30 domains. I am looking for the easiest way to identify which of the 1,000 email addresses contain any of the 30 domains. Thanks in advance.

[alansidman]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[jmb2019]

Thank you. See attached.

[huuthang_bd]

Please try this array formula

Please Login or Register  to view this content.

[jmb2019]

Thanks. This seems to work for the first cell (A2), but the other cells all show as FALSE.

[huuthang_bd]

Please use that formula in array formula mode. To use a formula in array formula, press Ctrl + Shift + Enter after typing the formula.

[alansidman]

Here is a VBA solution that Highlights the cells found

Please Login or Register  to view this content.