How to find a string within another list of strings?

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

Dear Matt,

pls give the example file.

Regards,
Nandu Satpute

try below formula

=IF(IFERROR(MATCH("*"&Domains!A1&"*",Dump!$C:$C,0),FALSE),TRUE)

Hi,
I really appreciate both your help, however, i have two issues. The first is that the formulas are still unable to capture instances where the lookup String is very long (>200 Characters)

I used the formulas and found two examples of this issue for domains:
nissan.nl
dodge.ca

These two domains belong in a very long string in (dump). Is this a limitation of excel? why is it unable to capture this? if i use a ctrl-F, it finds it just fine (so my thinking is that there must be a way to capture this!

The second concern I want to ask you guys...is there a way to find an exact match separated by the commas or bars (|)? For example, the formula will find bug.com in various instances i.e. deadbug.com, happybug.com, lifeofbug.com. What happens on my end is that since i see that it found bug.com, i'll delete it since i don't want the duplicate, when in fact, bug.com does not exist in my original file?

You have already been so much help. Currently i use 5 different formulas to achieve the same thing...you guys helped me bring it down to one!! WHOOO!

Again, I appreciate the help, hope to hear back soon :-)

Matt

Vlady, you rock my world...Thank you very much!

Now I have one last question, which may be just laziness asking...but I want to learn how to fish (metaphorically) what's a good starting point to become a spreadsheet guru? I want to be able to confront novel situations and be able to find solutions. This would take an understanding at the deepest levels--how the formulas function, how excel even makes the calculation....How did you get a such a deep grasp on excel? Did you just start by looking at formulas and thinking of clever ways to use them? did you break down formulas to see how the function? Did you read a book, take a class? Can anyone recommend any textbooks, or good starting points?


I once read a great quote which said something like, "If you don't know where you are going, any path will get you there."...which is exactly what I intend to do, but guidance would be nice

Thank you!
Matt