I have seven products which all have a different costs. Of those seven products I have four value-added functions that can be performed. Depending on the seven products each value-added activity has a certain cost. What I would like to do is create a worksheet that allows me to drop down the correct product and then pick the correct value-added activity and the cost that corresponds.
I have attached a file that may explain what I am looking for better. Thank you for your help.