data validation list

[deckerp]

Hi,
I have following question:

sheet 1
A B C
Category Product Variation
Clothes shoes women
Clothes shoes men
Clothes jeans women
Clothes jeans men
food drinks cafe
food meals muffin
food drinks soft drink


In sheet I need to change te drop down of B and C according to the values in sheet1

Thanks

[Marcelo Branco]

Take a look at
Excel Data Validation -- Dependent Lists

M.

[deckerp]

it is a bit more complicated. here is my table:

	A	B	C
5	Category	Product	Customer Segment
6	Ticket	2 hours	Child
7	Ticket	2 hours	Teenager
8	Ticket	2 hours	Adult
9	Ticket	2 hours	Family Card
10	Ticket	2 hours	Family Card (additional child)
11	Ticket	3 hours	Child
12	Ticket	3 hours	Teenager
13	Ticket	3 hours	Adult
14	Ticket	3 hours	Family Card
15	Ticket	3 hours	Family Card (additional child)
16	Voucher	2 hours	Child
17	Voucher	2 hours	Teenager
18	Voucher	2 hours	Adult
19	Voucher	2 hours	Family Card
20	Voucher	2 hours	Family Card (additional child)
21	Voucher	3 hours	Child
22	Voucher	3 hours	Teenager
23	Voucher	3 hours	Adult
24	Voucher	3 hours	Family Card
25	Voucher	3 hours	Family Card (additional child)
26	yearly pass	3 hours	Child
27	yearly pass	3 hours	Teenager
28	yearly pass	3 hours	Adult

in the second sheet the data validation looks like this:

	B	C	D
12	Category	Product	Customer Segment
13

BUSINESS_DONE

Worksheet Formulas Cell Formula B12 =PAR!G6 C12 =PAR!H6 D12 =PAR!I6

B13 has a validation list that let me choose the CATEGORY

For C13 I would like to have a validation list that lets me select the product depending on the category in B13.
For D13 I would like to have a validation list that lets me selec the customer segment depending on the category in B13 and on the product in C13.

Thanks a lot.

[Marcelo Branco]

At the link i provided have you seen the topic Adding a Third Dependent List ?

M.

[deckerp]

At the link i provided have you seen the topic Adding a Third Dependent List ?

M.

I looked at it but it dont get it.

can you please help me and build the formula?

[deckerp]

At the link i provided have you seen the topic Adding a Third Dependent List ?

M.

I looked at it but it dont get it.

can you please help me and build the formula?

[Marcelo Branco]

1st Step
Create the list Category
Ticket
Voucher
Yearly pass

Select B13
Data > Data Validation > List
=Category

2nd step
Create the lists Ticket and Voucher
2 hours
3 hours

Select C13
Data > Data Validation > List
=INDIRECT(B13)

Once you have done these 2 steps, later we'll set up the 3rd step, ok?

Tell me if everything is working fine till now.

M.

[Marcelo Branco]

Question:
Yearly pass has only 3 hours as a possible value?

M.

[deckerp]

yes

Question:
Yearly pass has only 3 hours as a possible value?

M.

[deckerp]

followed your instructions.

cannot choose drop down in C13

Error Message: the source currently evaluates to an error. Do you want to continue?