Formula based on a Named Range

[mmchaley]

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

[mikeava]

Hi - can you please attach your file?

[BadlySpelledBuoy]

We have a complete misunderstanding of your exact requirement based on the description above.

We have a wanting to see an example workbook.

We have a stronger wanting for that example workbook to show us your original layout and your desired outcome.

We know you will post an actual sample workbook and not just pictures of it.

Cheers.

BSB

[mmchaley]

Added attachement

[Bo_Ry]

Please try at F2

=REPT("Yes",COUNTIFS(ISP,D2))

or
=IF(COUNTIFS(ISP,D2),"Yes","")

[mmchaley]

Thanks much, works great!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.