Tom,
From what I could tell, the drop-downs aren't dependent at all. Regardless of who's paper it is, all the print types will be available to choose from. And regardless of the combination of who's paper it is and selected print type, both paper sizes will always be available to choose from.
Attached is a modified version of your posted workbook. The drop-downs have been populated in 'Selections'!B1:B3 using named ranges. In 'Selections'!B5 is this formula to get the price per sheet:
=IF(COUNTA($B$1:$B$3)<3,"",VLOOKUP($B$2,Prices!$B$2:$F$6,MATCH($B$3,Prices!$C$7:$F$7,0)+MATCH($B$1,Prices!$C$1:$F$1,0),FALSE))
Bookmarks