I'm trying to do a drop-down list IF another cell doesn't equal "no" So I have two columns: one with a drop-down list containing "yes" and "no" and in the other column I want to do a drop-down list only if the previous column is different than "no".

I tried many things, googling all the internet but doesn't find a solution...


Y1: =IF(A1="yes", {C1:C}, )


demo spreadsheet

  • hmm i'm on excel but anyway, the problem is that I don't want "c" column and when A is "yes" B should be a dropdown list not just print "aa bb cc"
    – Joop
    Apr 9 '19 at 18:38
  • @Joop answer updated
    – user0
    Apr 9 '19 at 18:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.