Help with Excel Dependent Drop Down List

Copper Contributor

I'm having trouble when creating a dependent drop down list. After creating my selection, I go to the specified cell and try typing =indirect(E2) into my data validation list but an error message pops up and I don't know how or what to fix. 

1 Reply
Does E2 contain text that's also a name of a named item?