Multiple validation lists

**hidde51** · 10-12-2009, 11:27 AM

Still really new to all this and could use a little help as i work through this worksheet. starting off simple for some I"m sure.
If you look at the worksheet i have attached you will see a pull down list in A3, it only has but 2 options (composite or portfolio) what i need is for cell C3 to give me a drop down list of the size options depending on what i choose in cell A3. (all referencing the chart i made to the right (the chart will be hidden eventualy)
A3=composite:8.5x11
A3=portfolio:8x10 or 10x13

**NBVC** · 10-12-2009, 11:43 AM

Have a look here for tips on setup.

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

**hidde51** · 10-12-2009, 01:12 PM

ok now I think i figured out the pull down lists to specify the options.. now here is my next hurdle.
After the style and size are chose from the list options. I need cell D4 to find the price per page (from the chart to the right) depending on what (size & Style were chose)

any formula suggestions here?

**JBeaucaire** · 10-12-2009, 01:21 PM

Actually, it depends on what Size, Style and PaperType (or whatever you call E-Surface, Metallic and True B&W).

You'll need to add that choice into your "options" before a subprice can be found, yes?

BTW, this question isn't clearly related to dependent drop boxes. As per forum rules, you really should mark this thread as SOLVED and start a new question for this.