Microsoft Excel - How do you embed a list of values within a vLookup table (or other function)

Asked By Von M on 07-Feb-13 01:19 AM
What I'd like to do is be able to have multiple selections in a list. It's kind of hard to explain without an example, so here's an over simplified (and kind of silly) example.

Say the main choice is the color of a car.  The color of the car determines the style and color of seats available. For some selections, there is a 1 to 1 ratio, so vLookup works just fine - example: red car, bucket seats.
But, for some selections, there are more choices - example: red car, white, black or gray interior

Instead of having the multiple results together ("white, black or gray"), I'd like it to be a list that drives another selection.  I tried a list of values, but, I'm obviously not doing something that needs to be done, because it doesn't bring the list of values to the destination cell - I have to select in the list in the table for the vLookup reference. 

I tried attaching an example, but, for some reason, the Document Manager doesn't have the Upload button.

John D replied to Von M on 07-Feb-13 07:41 AM
Hi
See the links attached can help you. It's a dependent dropdown list
http://www.contextures.com/xlDataVal13.html
http://www.contextures.com/xlDataVal15.html
Von M replied to John D on 09-Feb-13 06:59 PM
Excel Multiple choice example.zip
Thanks for the reply, but, those don't seem to be quite what I'm looking for (unless I'm just not understanding them at all - which is always a possibility).
The document manager has an upload button now, so I'm attaching the example I wanted to attach before.



In the picture above, the selection of "Red" fills in the seat style as "bucket" and the Interior Color as "white, black or gray".
For "Black", I tried creating a list of values instead of just putting all the colors together in the cell.  My hope was that, when "Black" was selected, it would then have the list of values to be selected in the seat style. 
However, the selection from the list of values still has to be made in the source list (in cell C:10) - and that is not feasible, as I would like to keep the lists that drive the selections hidden (in the real spread sheet, there are several tabs, one of which is "background data" which will be hidden, just to keep things clean).
In the pictures below - I'm trying to get B:4 to have a functioning list of values, but, it only pulls what has been selected in C:10.



I'm trying to get each of the cells which have choices to present the choices as a list of values, as the results of B:4 and B:5 will drive information in other parts of the worksheet.