If(Search to say "YES" or "NO" if cell contains specific text

**Alt=** · 01-24-2014, 02:57 PM

I have a column of cells with names in them like the example below. I'd like to have a formula in another cell that will tell me "YES" or "NO" if the original cell contains "Mark". I'm thinking I can use an If(Search formula but I can't seem to figure it out.

Bob, Mark, Lisa, Fred

Thank you

P.S.: I've read the forum rules and searched fir this already. This is my first post so please take it easy on me if I did something wrong.

**Tony Valko** · 01-24-2014, 03:03 PM

Maybe something like this:

=IF(COUNTIF(A2,"*Mark*"),"Yes","No")

**Alt=** · 01-24-2014, 03:06 PM

Excellent! Thank you Tony.

**Tony Valko** · 01-24-2014, 03:23 PM

You're welcome. Thanks for the feedback!

If(Search to say "YES" or "NO" if cell contains specific text

LinkBack

Thread Tools

Rate This Thread

Display

If(Search to say "YES" or "NO" if cell contains specific text

Re: If(Search to say "YES" or "NO" if cell contains specific text

Re: If(Search to say "YES" or "NO" if cell contains specific text

Re: If(Search to say "YES" or "NO" if cell contains specific text

Thread Information

Users Browsing this Thread

Similar Threads

Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"

[SOLVED] How to USE """"" cells count """"" change font color

Date format of just "st" "nd" "rd" and "th" with text included

[SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"

How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro

Bookmarks

Bookmarks

Posting Permissions