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...

1 Answer 1


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, 2019 at 18:38
  • @Joop answer updated
    – user0
    Apr 9, 2019 at 18:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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