Dependent Drop Down Lists

[marshak]

Hello everyone!

I, once again, need your expertise.

In the attached sample file, I am trying to create dependent drop down lists (in worksheet, REPORTNG) based on the data in worksheet, Mat Type List.

So, what is chosen for MATERIAL, should determine the drop down options for SUBCATEGORY
then, what is chosen for SUBCATEGORY, should determine the drop down options for MATERIAL TYPE.

I initially tried using the left table in the Mat Type List worksheet, but my entries would contain blanks. So then I tried creating pivot tables which seemd to work okay. Problem is, I haven't figured out how the droption options for MATERIAL TYPE can be linked and dependent on chosen SUBCATEGORY.

Thanks so much for your help. Any help would be greatly appreciated!

[Bo_Ry]

Set Pivot layout to Tabular and repeat all items

Data validation list at
A7
='Mat Type List'!$F$3:$F$16

C7
=OFFSET('Mat Type List'!$I$2,MATCH(A7,'Mat Type List'!$H$3:$H$100,),,COUNTIF('Mat Type List'!$H$3:$H$100,A7))

E7
=OFFSET('Mat Type List'!$N$2,MATCH(C7,'Mat Type List'!$M$3:$M$253,),,COUNTIF('Mat Type List'!$M$3:$M$253,C7))

[marshak]

Thank you sooooo much! Exactly what I needed!