Hi all - apologies for the less than helpful title. Hopefully the below will make more sense.
I am trying to identify whether a text string in one cell contains the whole text another cell. In my example, the text string I am testing is a URL (e.g. www.website.com/example/) and I am comparing it against a long list of domain names (e.g. mysite.com, yoursite.com, website.com) to see if there is a match.
In the example above, if the URL contained either mysite.com, yoursite.com or website.com, the output would be 'Yes'.
Please see the attachment. The URL list is in the URL tab, column A, with output in column B (and what its supposed to come out as in columnD). The domain list to compare against is on the domain list tab, column A.
I've dug around, and come up with this..=IF(SUM(NOT(ISERROR(FIND('Domain List'!B2:B19,A2)))*1)>0,YES)... but unnsurprisingly, it doesn't work.
Anyone understand what I'm trying to do? Anyone got a clue how to do it?
Anyone? Anyone? Bueller? Anyone?
Rob
Bookmarks