MichaelSchulz
Board Regular
- Joined
- Apr 10, 2014
- Messages
- 64
I have the following table:
On another tab, I have a sheet with three cells with dropdown values.
The Brand dropdown is a list of unique values from the Brand column in the table
The Type dropdown is a list of unique values from the Type column in the table
What I want is for the Product dropdown to display the values based on the selections from the Brand and Type dropdowns.
Examples:
if the User selects Brand A and Type 200 then the only options displayed in the Product dropdown would be Product_03 and Product_04
if the User selects Brand B and Type 100 then the only options displayed in the Product dropdown would be Product_07 and Product_08
How can this be done? Without VBA?
| Brand | Type | ProductName |
|---|---|---|
| Brand A | 100 | Product_01 |
| Brand A | 100 | Product_02 |
| Brand A | 200 | Product_03 |
| Brand A | 200 | Product_04 |
| Brand A | 300 | Product_05 |
| Brand A | 300 | Product_06 |
| Brand B | 100 | Product_07 |
| Brand B | 100 | Product_08 |
| Brand B | 200 | Product_09 |
| Brand B | 200 | Product_10 |
On another tab, I have a sheet with three cells with dropdown values.
| Brand | (Brand dropdown) |
| Type | (Type dropdown) |
| Product | (ProductName dropdown) |
The Brand dropdown is a list of unique values from the Brand column in the table
The Type dropdown is a list of unique values from the Type column in the table
What I want is for the Product dropdown to display the values based on the selections from the Brand and Type dropdowns.
Examples:
if the User selects Brand A and Type 200 then the only options displayed in the Product dropdown would be Product_03 and Product_04
if the User selects Brand B and Type 100 then the only options displayed in the Product dropdown would be Product_07 and Product_08
How can this be done? Without VBA?
