Using Symbols (&/-) in In Two Dependent Drop Down Boxes. Can't get the VLOOKUP to work!!!

D

Darren D.

Hey all,

I have a category list of products and then a list of brand names for
each product. So, I set up a series of drop down boxes (using Data
Validation) for the categories and then a second series dependent
which category you pick in the first, for the brand names. HERE IS MY
PROBLEM: When I set up the category list I had to create them as
One-Word-Names. I tried to set up a lookup table with the real
category names (multiple words and symbols), but I can't seem to get
the first drop down box to reference the lookup without then screwing
up the Data Validation of the second (dependent) drop-down box? If
anybody can follow this I'm impressed. If you can help, I'll be
indebted. Thanks in advance.

Regards,

Darren
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple dependent drop down boxes 1
Conditional Drop Down Boxes 1
Multi-level dependent data validation 3
How to create 2 dependent drop down lists from 1 original drop dow 5
Data Validation & Drop-Down Lists 4
Dependent drop down dynamic range formula, off sheet. 7
Data Validation & Drop Down Boxes 2
Drop-Down Boxes In Adjacent Columns 1

Top