Data validation help please

[mq1973]

Hi guys,

I have this issue and I really need an expert help.

I have this table

Data_Validation.jpg

C15 is a dropdown list of manufacturing lines (1, 2 and 3)

1) I need to create a dropdown list in C19 that shows all products made on a given manufacturing line based on my selection in C15 list. In other words, if I select 1 in C15, I should get in C19 a dropdown list that shows product 1, product 4 and product 7
2) I need to create a dropdown list in C21 that shows all products made on a given manufacturing line and of type A only, based on my selection in C15 list. In other words, if I select 1 in C15, I should get in C21 a dropdown list that shows product 4 and product 7