Kids furniture inventory

[strangedenial]

Hi all,
I'm pretty sure this one is really a piece of cake but somehow I can not get it all together and find a solution
Let's say that I have a product , which is a car-bed.
The product has these vars :

- Product code
- Sizes
- Colors
- Brands
- Price (which depends on the size and options)
- Option 01
- Option 02

So I'm giving 3 products as an example

Brand: BMW
which has these vars
Colors : Red (Product code: B01) , Blue (Product code: B02), White (Product code: B03)
Sizes and prices : Size 01 (10 $) │Size 02 (20 $) │Size 03 (30 $) │Size 04 (40 $)
Options : Option 01 (+10$) , Option 02 (+20$)

Brand: Ferrari
which has these vars
Colors : Green (Product code: F01), Blue (Product code: F02), Red (Product code: F03), Yellow(Product code: F04)
Sizes and prices : Size 01 (10 $) │Size 02 (20 $) │Size 03 (30 $) │Size 04 (40 $)
Options : Option 01 (+10$) , Option 02 (+20$)

Brand: Audi
which has these vars
Colors : Black (Product code: A01), White (Product code: A02), Yellow (Product code: A03), Blue (Product code: A04)
Sizes and prices : Size 01 (10 $) │Size 02 (20 $) │Size 03 (30 $) │Size 04 (40 $)
Options : Option 01 (+10$) , Option 02 (+20$)


So what do I need ?


cell C02 - drop down 1 - will have a list of all Brand Names of that product. (in example only 3 but in real a lot more)
cell D02 - drop down 2 - will have all the available colors of the chosen brand in drop down 1
cell E02 - drop down 3 - will have all available sizes
cell F02 - Check box - will be the Option 01 (+10$)
cell G02 - Check box - will be the Option 02 (+20$)
cell H02 - price without options (chosen size from drop down 3)
cell I02 - price of total chosen options
cell J02 - Total price


I'm not pretty sure if I was clear enough, if you don't understand clearly what I need, please ask me to explain it more detailed.
Thanks in advance!!!

 

[Logit]

.
Different methods to consider :

Dependent Drop-down Lists in Excel

Creating a Dependent Drop Down List in Excel [Step-by-Step Tutorial]

 

[strangedenial]

.
Different methods to consider :

Dependent Drop-down Lists in Excel

Creating a Dependent Drop Down List in Excel [Step-by-Step Tutorial]

I was just working on it
Thanks a lot!

 

[Logit]

You are welcome.