Results 1 to 7 of 7

Thread: Need help with what should be an easy formula!!

  1. #1

    Need help with what should be an easy formula!!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I searched online for help on this but no luck, I basically need a formula for the following scenario.....(the formula should be pretty easy, but unfortunately I'm not very good with formulas)

    If "word x" is anywhere in column C, display a "Yes" next to "word x" in column B. I want to do this for a very long list of words. Pleae see attahced image. Any help on this is greatly appreciated!

    Click image for larger version. 

Name:	excel formula.jpg 
Views:	22 
Size:	43.0 KB 
ID:	3092

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    Just add

    =IF(C2="word x","Yes","")

    to B2 and copy down.

  3. #3
    Hey Bob, unfortunately that formula wouldnt work (it's actually backwards, I think) and the words in column A differ greatly. I basically need it like this....

    Search for "word 1" in ALL of column C, and if it appears anywhere in the column, display a "yes" next to it.
    Search for "word 2" in ALL of column C, and if it appears anywhere in the column, display a "yes" next to it.
    Search for "word 100" in ALL of column C, and if it appears anywhere in the column, display a "yes" next to it.

    and so forth.

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    That will teach me, I didn't look at the picture thinking I understood from your words alone.

    Try this instead in B2 and copy down

    =IF(COUNTIF(C:C,"*"&A2&"*"),"Yes","")

  5. #5
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi Primestar,
    Pl check the attachment.
    Attached Files Attached Files

  6. #6
    Conjurer Beamer's Avatar
    Join Date
    Nov 2014
    Posts
    109
    Articles
    0
    Excel Version
    365
    Hi sambit, if the "Keywords" in column A will always be the last words in the cells of the "Product" column try removing the last * like so:

    =IF(COUNTIF(C:C,"*"&A3),"Yes","no")

  7. #7
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Thanks Beamer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •