T-shirt brand color and size

0

Hello everyone, i hope someone can help with this complicated issue, i have 5 Brand Name T-Shirts and they all have different colors and sizes for each brand, i would like when i select a brand i want it to show me which ever color and size i select i want it to show me the available amouth in that size.  For example i select a brand name Gildan i then select the Color Red then i select the size small it show me i have 10 small T-shirts in that size available. FYI it has to be automated drop down menus 

Answer
Discuss

Answers

0

You can make the drop-down menus using data validation and then use the SUMIFS() function to return the inventory amount.

Attached is a spreadsheet showing you how to do this.

To use data validation for the drop down menus, follow our tutorial here: Make a Data Validation Drop Down List Menu in a Cell in Excel

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login