Find Text In Range With Part Of Text & Return True or False

**tis28** · 06-26-2013, 01:11 PM

Hi,

The example is:

Column A are some categories for reference, column C are the sentences. I would like to have a check in column D that if the sentences contain the categories of food.

But i have no idea to have the formula use for finding text in a range of cells... Can this work in Excel Formula?

THANKSTesting.xlsx Testing.xlsx

**AlKey** · 06-26-2013, 01:37 PM

Try this:

=IF(SEARCH(TEXT(A2,"@"),C2)>0,"YES","NO")

**Ace_XL** · 06-26-2013, 01:39 PM

=IF(ISNUMBER(SEARCH(A2,C2)),"Yes","No")

**Craig K.** · 06-26-2013, 01:41 PM

try this
=IF(FIND(A2,C2,1)>0,"Yes","No")

**tis28** · 06-27-2013, 10:04 PM

Thanks for everyone's answer.

Sorry that I made some unclear information. All the formular I use for the first sentence is work, but it will have some problem when trying the second one. Also if there is a third sentence is "I love strawberry.", it cannot specify the "strawberry" in sentence & cannot return "Yes". Any formular can do for this case?

Thanks for help!

**Craig K.** · 06-28-2013, 12:06 AM

I guess we all dropped the ball on that one, you just need to wrap an iferror() function around our solutions.
=IFERROR(IF(FIND(A2,C2,1)>0,"Yes"),"No")
-or-
=IFERROR(IF(ISNUMBER(SEARCH(A2,C2)),"Yes"),"No")
-or-
=IFERROR(IF(SEARCH(TEXT(A2,"@"),C2)>0,"YES"),"NO")