Forum Discussion
Solved
Dynamic, Horizontal Named Ranges for Use in Dependent Drop-Down Lists
Hi folks, I've been having some trouble with using a dynamic, horizontal named range in a dependent drop-down list. My situation is the following: I am doing up a budget for myself and listing th...
- Thanks for the response. Thankfully, I have figured it out with - I kid you not - the most simple solution in the world. Since my multiple locations for a single merchant were being returned horizontally by a spill formula, all I had to do to refer to that spill formula as a named range as it kept expanding was add a '#' to the end of it. Can't believe it took me one character to solve the problem. Thanks again anyway.
Perhaps this gives you an idea for an alternative approach: https://jkp-ads.com/Download.asp#DependentValidation
Thanks for the response. Thankfully, I have figured it out with - I kid you not - the most simple solution in the world. Since my multiple locations for a single merchant were being returned horizontally by a spill formula, all I had to do to refer to that spill formula as a named range as it kept expanding was add a '#' to the end of it. Can't believe it took me one character to solve the problem. Thanks again anyway.