Search & Find String of Words

[flds]

Hello,
I am looking to create a formula.
My requirement is, I have over 1200 rows of data and filling up. I am trying to match text. I have text in column A & B. I need the same string of words contained in Col 'B', to match in Col 'A'. (String of words in Col 'A' could be long in some rows). Return "Yes" or "No" in Col 'C', on same row as match found in Col 'A'.
Hope I am clear in my requirement.

I googled and tried these formulas, and failed

"IFERROR(IF(MATCHif("*"&B1&"*",A:A,0),"yes",),"no")"

"IF(COUNTIF(A:A, "*"&$B$1&"*"), "Yes", "")"

Your help would be greatly appreciated. Thanks

 

[Peter_SSs]

I modified the D2 formula =IF(ISNUMBER(SEARCH(" "&B1&" "," "&A2:A23&" ")),"Yes","No") I added the asterisk "*"&B1&"*". This gives me the search for multiple words.

Perhaps I am not understanding exactly what you are trying to do or how you modified the formula, but as I understood the requirement my existing formula already finds a multiple word string and your modification might stop the formula looking for words and find text strings instead.
Below I have used my existing formula in D2 and what I think your modification is in E2 and you will see in row 10 that your formula has found the text string "one two three" but not the words "one two three"

If I have misunderstood, to help me understand, could you please post your exact modified D2 formula, an example of the B1 value and one example from column A where your modified formula gives you what you want and my existing one does not?

flds.xlsm
	A	B		D	E
1	Text	one two three		Word match
2	one two three four			Yes	Yes
3	onetwothree			No	No
4	one two three			Yes	Yes
5	zero one two three			Yes	Yes
6	one three two			No	No
7				No	No
8	five six			No	No
9	zero one zero two zero three zero			No	No
10	twentyone two three			No	Yes
Match text (2)

Cell Formulas
Range	Formula
D2:D10	D2	=IF(ISNUMBER(SEARCH(" "&B1&" "," "&A2:A10&" ")),"Yes","No")
E2:E10	E2	=IF(ISNUMBER(SEARCH("*"&B1&"*"," "&A2:A10&" ")),"Yes","No")
Dynamic array formulas.