Search partial text in an array

Try this:

Please Login or Register  to view this content.

note:
in the code above, InStr function use default comparison which is case sensitive. If you want it to be case insensitive then you can replace :

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

Originally Posted by YasserKhalil

Mr. Akuini
Thank you very very very much for this great solution
It works exactly as I need .. working like charm
I tested it in the original workbook and it was fascinating
Best regards

You're welcome & thanks for the feedback.

Originally Posted by YasserKhalil

@Mr. Akuini Sorry for disturbing you again
I added this text "this is random big city" and run the code and it gives me empty result in column M
I need to put the text "Out" instead of ""
I tried this edit

Please Login or Register  to view this content.

but doesn't work well

I'm not sure what you want, but maybe this:

Please Login or Register  to view this content.

but if what you really want is you add some other 'cities' then you want them be identified as 'out' then you need another code.

OK, glad to help.

Originally Posted by YasserKhalil

Thanks for reply
I still have the problem
In post # 7 I put an image to illustrate the desired output.. In the yellow cell this is the result when there is no string found, I just need to put the string "OUT" instead of this empty

Ok, try this:

Please Login or Register  to view this content.

Originally Posted by YasserKhalil

Mr. Akuini
Thank you very much for this great and wonderful help
Now it is perfect for me
It is working like charm
Best and kind regards

You're welcome & thanks for the feedback