Hello,

Can someone help me with this?

I want to be able to search for a list of strings against another list of strings and return True/False, or the sought value--doesn't really matter here. The list that I'm searching for is a list of Internet domains(5-20 characters). The list that i'm searching against is a list with strings containing anywhere from 10 to 1500 characters (in each string).These strings are made up of internet domains separated by "|". I can replace these with commas if necessary. In addition, the list i'm searching against is about 20,000 lines and growing.

The current formula, which was was written for me by my employer, seems to break after string that we're looking up against exceeds a certain length. So as a way I've been coping with this is manually using the Find, Ctrl-F, function and looking for the value of interest that way. Takes me forever to get my work done doing this...

Any feedback would be greatly appreciated!!!

Sincerely,
Matt