answer to multiple validation data lists

  • Thread starter Thread starter GreenIz
  • Start date Start date
G

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.
 
Back
Top