Lookup range of values to see if any of them exist in a single column

Hi,

I have a worksheet which contains 5 columns of email addresses per row. I have another worksheet which contains a single email address column per row.

I want to find out if any of the 5 email addresses on the first worksheet exist anywhere in the email column of the second worksheet.

In other words:

On first worksheet
Name | Email1 | Email2 | Email3 | Email4 | Email5

On second worksheet:
Name | Email

Do any of the email addresses on the first worksheet exist anywhere in that email column on the second worksheet.

Hope someone can help

Hi Fotis,

Thanks so much for replying. I tried your formula, but it doesn't seem to work for me I'm afraid. I can see what you are doing with the formula, but all I get is the "nothing exists" outcome, even when I can see that one of the email addresses I am testing for does exist in the other sheet.