Hello all,

Not sure where to start with this formula so I need some guidance

I have a list of ISP URLs I have named ISP

I have a list of failed emails I have dropped the email name and turned into a URL, I have these values in a column labeled URL

I have a column I have labeled ISP

In the ISP column I want to add a "Yes" when the value in URL matches one of the values in the named Range ISP.

I know I could accomplish this with a very long embedded If statement, but is there a better, more elegant way?

Thanks,
Mark