See Debra Dalgeish's site for instructions for creating dependent DV lists.
http://www.contextures.on.ca/xlDataVal02.html
Gord Dibben MS Excel MVP
On Tue, 9 Jun 2009 09:16:02 -0700, Emma
wrote:
I need to display a result based on what a user selects from a list of options.
Example:
Selection A - Make of car
Mazda
Ford
GMC
Porshe
Toyota
Selection B - Number of Doors
2
4
5
Result possibilities:
If the user selects Ford and 2 door then the result would come up with an
F-150.
If the user selects Mazda and 5 door then the result would come up with a
Mazda 3.
etc.
How do I do this. I can create drop down lists and list boxes, or control
boxes to show the Selection A & B however I don't know how to get it to
display the results based on the selection.
Thanks for your help!