Excel help

[picoda]

I'm not sure how to search for this, if it's already been answered:
I have 2 adjacent cells, each with a unique drop-down list. If I pick something from the first list, I want the options for the second cell list to be limited by the first choice. For example, if the choices for the first list are "fruit" or "veg", and I choose "veg", then the choices available in the second cell would only be in the veg category. But if I chose "fruit" for the first cell, no veg options would be in the list for the second cell (only fruit). Does that make any sense?

 

[rwpritchett]

Here's a step-by-step on how to do this. It uses the INDIRECT excel function:

http://www.contextures.com/xldataval02.html

 

[picoda]

Excellent! Thanks for that. Kind of spooky that they used the same fruit/veg example!

 

[picoda]

Best answer selected by picoda.

 

[rwpritchett]

Excellent! Thanks for that. Kind of spooky that they used the same fruit/veg example!

That's funny... when I found that link I thought maybe you had already seen it but didn't understand the steps. I thought that was where you pulled your example. :lol: