How to create conditional pull-down list of options in calc?

[dennisthetiger]

This is kind of a weird one. I’m looking to create a pull-down list of options that are available if an adjacent cell contains text.

For instance, if a1=“oranges”,b1 would contain a pull-down that would contain “navel,valencia,blood”. Conversely, if a1 = “apples”, said pull-down in b1 would contain, say, “fuji,gravenstein,honeycrisp”.

Long and short - is this even possible? If so, how do I create this?

[Ratslinger]

Hello,

Take a look at the answer by Jim K in this post → Drop down box and database range question