I've been searching for a formula on the forum for some time now and have not found this exact scenario.
I'm looking to have a formula that indicates if there is any text in cell C2 that matches any text in cell B2.
Yes
B2 C2
Acme Mfg. ACME MFG CO
No
B2 C2
Bob's Fruit Jerry's Bread
I found a formula that ALMOST worked but failed with the Acme example above
=IFERROR(LOOKUP(9.99999999999999E+307,SEARCH(Sheet4!B2,C2),Sheet4!B2),"")
Please and thank you.
~ Ky
I'm looking to have a formula that indicates if there is any text in cell C2 that matches any text in cell B2.
Yes
B2 C2
Acme Mfg. ACME MFG CO
No
B2 C2
Bob's Fruit Jerry's Bread
I found a formula that ALMOST worked but failed with the Acme example above
=IFERROR(LOOKUP(9.99999999999999E+307,SEARCH(Sheet4!B2,C2),Sheet4!B2),"")
Please and thank you.
~ Ky