If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
I am creating a list with Data>Validation>Allow>list and it requests the source for the list- all OK, but the list produced needs to depend on other factors, I have several named range's containing different lists.
I need to insert in the "list Source" box a cell reference, which contains a the name of the range ie "list46" and for the source to recognise this as a list to produce
Is it possible to lookup a named range to produce a list?
Sorry about the explanation very difficult to put in to words!
Cheers
Martyn
Last edited by martynduerden; 07-02-2009 at 06:17 PM.
These are called Dependent Drop Down lists and they use named ranges and INDIRECT() references in the proceeding drop boxes.
Here's a sample sheet I've posted showing how it's done. The sheet "CHOICES" has the dependent drop lists (and shows one of the dangers of using them) and the sheet "LISTS" shows the lists and named ranges in use.
If you've been given good help, use the icon in that post to give reputation feedback, it is appreciated.
Always put your code between [code] and [/code] tags.
“None of us is as good as all of us” - Ray Kroc “Actually, I *am* a rocket scientist.” - JB (little ones count!)
Lookup range for list
icon in that post to give reputation feedback, it is appreciated.
Solved
Linear Mode
