Dropdown list depending on another dropdown list and second condition

Hello,

I need help with an excel formula, which would really help me with my work and I just can't figure it out.

Example:
I have objects A and B. Each one of them can be small or large. I would like the color to be a drop down list, that depends on the drop down chosen in object and the certain column (small, large).

Capture1.PNG

I would need a following formula: if I choose from dropdown list the object A, than in the column Small, it would give me the options (dropdown) to choose either Black or Blue and in the column Large the options for Red or White.
If I choose from dropdown list the object B, than in the column Small, it would give me the options (dropdown) to choose either Black or green and in the column Large the options for Blue or yellow.

Capture.PNG


I hope you understand, what I need.

I would really appreciate your suggestions.


Shanaya