answer to multiple validation data lists

[GreenIz]

I posted a few days ago a question on how to make multiple validation
lists... I found a VERY simple work around just by trial and error and
thought I'd share.

In my example, i am making a computer system configurator and will make an
example here..

Cell A1 has a list of motherboards, let's say 2 of them. Part #'s in the
list are as follows MOTHERBOARDA
MOTHERBOARDB

Based on that selection, a list of chassis comes up. The list of compatible
chasssis for each motherboard is named after the motherboard selection (as
required) "MOTHERBOARDA" and "MOTHERBOARDB" so in the data validation area,
you select "list" and "=indirect(A1)" right? Well, what if you want to make
a list of compatible memory for the motherboard? You've already named the
chassis list after the motherboard name... so, name the memory list
something like "MOTHERBOARDAmemory" and the other one "MOTHERBOARDBmemory"..
in the data validation area, you select "list" and in the box, you type
=indirect(A1&"memory") and voila, it works. It adds the additional area in
quotes onto the list name (of course, you have to NAME your lists!!).

Just thought I'd post this because it took me a week to figure out this
simple thing. I went to many websites on dependant lists, and this is by FAR
the easiest workaround.

 

[Dave Peterson]

Debra Dalgleish has some nice pictures that describe this at:
http://www.contextures.com/xlDataVal02.html

And for what it's worth, you got a reply that pointed to this web page.