Create Drop Downs based on Conditions

**cmdeceia** · 10-17-2013, 01:34 PM

Hello -
I have a project where a customer can pick a product, once they pick the product, they can pick the type of label they want to apply to the product (some instances only have 1 label type option, other products have 3 different possible label type options), from there, they pick the quantity they want to purchase and then the price per label would ideally automatically populate.

I've been trying to do this using drop downs (if there is a better way to do this, please let me know!), but for the products that have multiple label options, I haven't been able to get the 3 options to show up, only one will show. Can someone please help with this?

Also, once that is sorted, based on the label type and quantity, how would I get the price to show based on the above parameters?

Any help would be appreciated. I attached the sheet and the work I've done thus far.

Excel Forum Help.xlsx

**Ace_XL** · 10-17-2013, 02:38 PM

Have a look here

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

**DBY** · 10-17-2013, 03:00 PM

Hello
I was working on this when Ace replied. It uses many of the ideas presented in the link provided. As I'd completed it I've uploaded the file as a working example. It uses five named ranges with data validation and an Index and Match formula in cell B6 Drop Downs sheet.

*I've amended the original example file to include a dependent drop down in the Label Type selection using the Indirect function and Vlookup. I'd forgot to include this originally.

Hope its of some use.
DBY