Drop Down List Based on Value of Another Cell

[manona]

Hi,

I am wondering whether it is possible to have a drop down list based on the value of another cell. I have already created dependent drop-down lists, but now I am facing more of a "if this cell has this value, create this drop down list, otherwise don't let the user enter a value".

Here are the lists we can work with for this example:

Foods	Fruits	Vegetables	Nuts	GoodBad
Fruits	Apple	Carrot	Cashews	Good
Vegetables	Banana	Corn	Almonds	Bad
Nuts	Kiwi	Kale	Peanuts

<tbody>
</tbody>

In in column A is found the Foods list (either fruits, veggies or nuts), and let's say we select Fruits. The drop down list in column B will then be either Apple, Banana or Kiwi. I have that covered!

My question is, let's say that ONLY for Fruits, I want the column C to have the "GoodBad" drop-down list - but only if column A has "Fruits" - otherwise I don't want the user to be able to enter any values (the sheet will be locked in the end, if this detail helps). Is this possible?

Thanks for your help!

 

[theBardd]

In yoiur DV, use a type of List and a source of

=IF(A2="Fruits",Q3:Q4,"")

referring to the actual GoodBad list of course

 

[manona]

Hi theBardd,

Thank you for your response! I've tried what you mentioned, and I get a message "The list source must be a delimited list, or a reference to single row or column".

Any way you could further explain the elements I need to enter in the formula you provided please?

Thanks a lot!

 

[theBardd]

Try setting it up with Fruits already selected, and make sure that you replace Q3:Q4 with the actual cell references.