Finding the word

[sathishkm]

Hi All,

I have a file which contains company and web. Here I need to find any of the company word matching in domain and it should return true or false.

Example:-

SimplexGrinnell LP www.simplexgrinnell.com True
CFT Corporation www.cftcorp.com True
Mapsco Inc www.Mapsco.com True
Lookout Mountain www.abc.com True

Even If single word matching in domain need to return true and also if all the word in the company matches in web needs to return true.

For more information. Please check the attachment.

[sathishkm]

Any solutions?

[sathishkm]

Any VB or macro code also fine.

[HaHoBe]

Hi, sathishkm,

please do not push as hard as you do. From the Forum Rules:

If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

If itīs really that important to you maybe consider to use the Commercial Services offered here at Excel Forum.

Ciao,
Holger

[AlKey]

This formula will get you close but not 100%. The problem is that domain names are not always consistent with the company names.

=IFERROR(IF(SEARCH(MID(SUBSTITUTE(A2," ",""),1,4),$B$2:$B$14),"TRUE"),"FALSE")

[sathishkm]

The above formula is not working properly in the below example.

Southeast Apartment Partners www.seaptpartners.com TRUE


It's returning False.

[XOR LX]

Hi,

This formula in C2 will return TRUE if any of the space-delimited substrings from the string in A2 is present in B2:

=SUMPRODUCT(--ISNUMBER(SEARCH(TRIM(MID(SUBSTITUTE(A2," ",REPT(" ",255)),255*(ROW(INDIRECT("1:"&1+LEN(A2)-LEN(SUBSTITUTE(A2," ",""))))-1)+1,255)),B2)))>0

Copy down as required.

Regards