Excel help

picoda

Distinguished
Feb 2, 2011
3
0
18,510
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

Distinguished
Mar 17, 2006
203
0
18,860
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: