• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data Validation in a price list

R

Rubo

New Member
Hi All,


I am trying to make a pricelist in excel where the product that is selected from one drop down menu will determine the color options in an other drop down menu. In column a there is a drop down menu containing about thirty different products. All the products do not come in the same color. In column b i want to be able to have only the color choices for the product that is selected in column a. So the data validation result in column b would be dependent on what is selected in the data validation is column a. Any suggestions?

Thanks,
 
Rubo


Firstly, Welcome to the Chandoo.org Forums


What you want is called Dependent Validation


Debra Dalgleish over at the Contextures website probably has the most comprehensive set of instructions on Data Validation around


Start here: http://www.contextures.com/xlDataVal02.html

But there are lots of links at the bottom of the page.
 
You must log in or register to reply here.
Back
Top