Good morning everyone, I'm having a little problem finding a solution for my cost simulation in Excel. Okay, imagine you have two products a T-Shirt and a pair of pants. Well that's the first criteria, then the two products you have them in two different sizes and colors which then is your second and third criteria. When all the criteria are clear I want Excel to spit out the correct price, does somebody know how to do that? I'm thinking of some sort of interactive drop down menu. Find here a scheme to understand my idea better : https://i.imgur.com/6r9GEBQ.jpg
I hope somebody can help me and thank you for every tipp/idea!
Bookmarks