On Thursday, February 5, 2015 at 5:16:26 AM UTC-6, Arun Gautam wrote:
I have data in excel Sheet1 as below:
Pizza Type Topping Size Crust
Non-Veg Olives Large Deep_dish
Veg Cheese Large Deep_dish
Veg Olives Large Thin_Crust
Non-Veg Bacon Large Cheese
Veg Cheese Small Thin_Crust


I want to prameterize values in Sheet 2 such that

Select Pizzza Type = <<
and Topping = <<
and Size = <<
and Crust = <<

so that all the above combinations will be covered.


Please help in this regard.

http://www.contextures.com/xlOrderForm01.html