Forum Discussion
Help with Excel Dependent Drop Down List
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?
