Hello,

I have several spreadsheets that I am needing to compare email addresses
from a column to a list of emails opened, simple enough, however the list i'm
comparing to contains many cells with multiple email addresses. Is there any
way to have excel look at each entry in a cell to compare with or do I have
to list each address in a different cell. Example:

A B
email1 email2 email3 Email5
email4 email5 Email6
email6 Email2

I need to have a formula that would compare column B to Column A and tell me
when it's found a matching email.

Is this possible?

Thanks.