How to do dependent variable drop down lists without using list names.

hmmm OK, you cannot have that ARRAY formula in C2 AND still use it as a Dropdown

You will need to put the ARRAY formula into a helper somewhere, then reference that with the DD