Excluding item in array?

[DMA]

Hello,

I have a tricky question. Is there a way to loop through a string array but not include one of it's items?

I'm comparing each word in the array against a string with two or more words. The thing is, I know one of the words in the array will be in the string.
I would like to know if a second word is found in the string. This is what I have:

Please Login or Register  to view this content.

If I run it the way it is, it will always find a match. I need to find the second match...

Hope I was clear enough. Any help will be appreciated. Thanks.

[Rick Rothstein]

If I understand what you want correctly, you are running the test backwards. Split the contents of cell D3 and the using InStr to see if each word is in cell A3's text. If the InStr test ever returns 0, that word is not in cell A3 so you can exit the Sub or do whatever you want when that happens. If you make it through the entire loop without hitting 0, all the words in cell D3 are in the text of cell A3.

[DMA]

Makes sense. I'll try that. Thank you!

[a2b1c1d1e1f1]

... If I run it the way it is, it will always find a match ...

???
Everyone's imagination is slightly different from the rest - please provide a small example with the input data and the expected result.