Results 1 to 4 of 4

Thread: IF statement not working because of dropdown

  1. #1

    IF statement not working because of dropdown



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

    Hello,

    I am looking for a formula for the foll:

    Cells A1:A10 contain names, which are in dropdown.

    I am looking for a formula which searches if a particular word say 'EXCELL' is in any of the cells A1:A10 and if present in any place within cells A1:A10 to place the info contained in cell B1 and if not place the info in cell B2.

    I have tried the below

    =IF(OR($A$1"EXCELL",$A$2"EXCELL",),(B1),(B2))... but this I have its extended to $A$10.

    This works if I manually type in cells A1-A10, but does not when cells A1-A10 are in the form of a drop down.

    Thanks.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =IF(COUNTIF(A1:A10,"EXCELL)>0,B1,B2)


  3. #3
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,467
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Slight typo in NBVC's (as always) excellent answer =IF(COUNTIF(A1:A10,"EXCELL")>0,B1,B2)

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Thanks for the catch Pecoflyer .


Posting Permissions

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