My boss has asked me to use Excel to create a "product selector" that will be used to aid the web developers when they create the real thing for the company's new website. There are 6 different categories of products, with multiple products in each category. In three of those categories, you can only choose one product, where in the other three you can select multiple products. I have created a multi-level data validation chart, where there are drop down menus next to each category for you to select all the products you are looking for. Now, I need to find a way where this chart will spit out the cost of each product selected into a pricing quote so the customer can see how much their order will cost. Even further, they can purchase their products two different ways... basically just the product or the product with full-service support. So I would like for the chart to spit out a quote for BOTH options so the customer can see a side by side comparison.

Can I get a multi-level data validation chart to spit out two costs onto another worksheet with the 2 quotes, depending on what is selected? Is this even possible?

If not... how could I do this? Multi-level vlookup? Filtering?

Thanks.