6 Data Validation lists depending on 1 cell value

  • Thread starter Thread starter beel
  • Start date Start date
B

beel

In have been looking over Debra Dalgleish's info (great stuff there)
and the advanced newsgroups but can't seem to find an answer to my
problem.

I have one validation box with 6 manufacturers in it, there are then 6
other cells with data validation in which depend on the value chosen in
the first cell. i.e. (in short)

Maker aaa bbb ccc
aaa part a part a part b
bbb part b part g part f
ccc part f part h part h

Indirect only links to first, I think I need offset but cannot work it
out, (comes of being old I suppose). I'm sure I am missing something
straightforward.
Any help would be much appreciated
Regards
Bill
 
Do the six cells require different lists? For example, does list 1 show
PartA for the selected manufacturer, and list 2 show PartB?

If so, how is the information stored in your workbook?
 
Hi Debra, nice to hear from you. Perhaps a better example would be
(just 3 for ease)

Maker aaagrades bbbgrades cccgrades aaabond
aaa vsp hye jpt vs
bbb thx jut lmd vbr
ccc thh kjh kbr
ytr

and so on for bbbbond cccbond and 3 other features.
It is stored as a series of lists on another worksheet in the same
book. Makers are in a name group 'Brand' which is the primary
question. The drop down boxes are needed for the relevant questions
grades, bond etc. I hope this is clearer

i.e.
Brand AAA

Bond choose from vs,kbr,vbr

grades choose from vsp,thx,thh,ytr
and so on

I hope this is clearer!

many thanks for your interest
Bill
 
Based on your sample data, I'll assume that the lists are named with the
Brand name, and the category name, e.g. aaagrades, aaabond

In the cell where you want the Bond dropdown, set the data validation
list source to: =INDIRECT($C$2&"Bonds")

where cell C@ contains the dropdown for brand.

For the Grades dropdown, set the list source to:
=INDIRECT($C$2&"Grades")
 
Debra you are a wonderful person!!
When I get fed up with the internet and some of it's issues I think of
these groups and remember this is what it is all supposed to be about.

Again many thanks
Bill
 
You're welcome! There's lots of great information posted in these
newsgroups, so I'm glad you found your way here.
 
I'm trying to do the same thing as beel, and I tried to use the example in
this thread by Debra, but I couldn't get it to work. Debra, can you try to
explain a little more to me how this works? Maybe use an even simplier
example, and list what goes into which cell, so I can try it.
In your solution, what is &amp, and &quot?

Bill Carr
 
The first link is a google page all written in another language. ??? But the
second link was great! The example in the second link was just what I was
trying to do. Thank you very much, Debra!
 
Back
Top