dependent drop downs, data validation, dynamic lists ..... incompatible?

[keithmct]

I have a triple dependent drop down list set where choice 1 (in E14) influences what appears in choice 2 (S14) list by doing this in data validation:

=INDIRECT(E14)

and choice 3 in U14 gets it's list from a range named from the concatenation of what's in choice 1 and choice 2 with this code in data validation.

=INDIRECT(SUBSTITUTE(E14&S14," ",""))

This works. However, when I made all my named ranges dynamic with help from the web like this:

=OFFSET(Fabrics!$B$1,1,0,COUNTA(Fabrics!$B:$B)-1,1)

data validation doesn't like it so no longer works.
I can type the choices in E14 data validation source manually as there are only about 8 items in that list but the others need fixing.
where should I go from here? or what other information can I give to further explain?

 

[Akuini]

I can't help you with the formula, but if you're ok to use vba, I might have an idea.
If you're interested in this method just let me know & if would be helpful if you can upload your sample workbook to a free site such as dropbox.com & then put the link here.

Here's an example of 2 dependent data validation with dynamic named range using vba:

dhee - 2 data validation, unique, dependent, dynamic row.xlsm

Shared with Dropbox

www.dropbox.com