Lookup range for list
Hello,
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.
Have a look.
Sample Files
http://www.excelforum.com/attachment...ndentlists.xls 3 levels
http://www.excelforum.com/attachment...dentlists2.xls 2 levels
http://www.excelforum.com/attachment...elfsorting.xls Self-Sorting lists of fruits by color choices
More reading:
http://www.contextures.com/xlDataval02.html
http://www.contextures.com/xlDataVal13.html
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Solved
Excellent reading thank you very much.
Martyn
but how about using the same in user forms.
Sorry not sure I follow you ?Originally Posted by excelkeechak
i m searching for the same from many days. if any body got the sol pls do post it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks