Drop Downs & Tables

[mojobaabby]

Here attached is my issue. I have 30+ tables all representing different products by width and by height. All products have different dimensions available. When I add a table to the drop down(B2) and ask the user to choose the series they want pricing on, then choose the sizes required(C2&D2), is there a way to draw only the widths and heights available for that table? Or does the drop down for width and height have to incorporate all possible sizes for all available tables?
This becomes confusing to figure out where one series size stops and another begins.
Thanks in advance for any help!!!

this is my formula for finding and matching the tables currently.

=IF(COUNTBLANK(B2:E2)=2,0,INDEX(INDIRECT(B2),MATCH(E2,INDEX(INDIRECT(B2),0,1),0),MATCH(D2,INDEX(INDIRECT(B2),1,0),0)))

[DonkeyOte]

Given the Table names are fixed references you should find you can create additional Named Ranges (Dynamic) and use those as Source for your DV cells.

ex. with D2 the active cell create the following:

Please Login or Register  to view this content.

Highlight D2:D5 and set DV to be List with Source =_DVWidths
Then repeat for E2:E5 but with Source =_DVHeights

As you alter the Series so the options should adjust
(note with DV if you revert the Series post selection of Height & Width the DV cells won't clear - for that you would need VBA)

[mojobaabby]

i hate to say this but i think I may have gotten it
Thanks