Hi, I have seen variations of this question posted a few times on here, but nothing that can exactly help me with what I am looking to do.
Put simply, my company has various patterns at various price ranges. I would like to have it set up wherein if Pattern "a" is selected, price range "b" is pulled up automatically. There would but numerous patterns referencing each price range.
Is this something that Excel is capable of doing?
I have attached a simple worksheet.
I appreciate any and all help!
Your sample sheet does not demonstrate your need. We already know how to do basic Data Validation lists.
What you're looking to create are called Dependent Drop Down lists and they use named ranges and INDIRECT() references for Data Validation lists 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 FilesThe files you want are:
--DependentLists3.xls - 3 levels
--DependentLists2.xls - 2 levels
--DependentLists-SelfSorting.xls - Self-Sorting lists of fruits by color choices
_________________
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks