Hi gang
I't hoping for some help on my spread sheet, I'm trying to get a second drop down list in C10 from information supplied from drop down B10. Example: if I chose drywall C10 would then drop down to allow me to choose a item from the drywall list of another sheet "List". I've upload a work sheet to show my issue.
Any help would be appreciated.
ThanksScope sheet.xlsx
use indirect data validation
see attached
Created named ranges for all your DV except for demo/landscape (because you cant have "/") in part of named range
suggest either breaking this up or face some text combination to indirect
like iferror/left/find
more reading here if you require it
http://www.contextures.com/xlDataVal02.html
Last edited by humdingaling; 09-01-2014 at 09:44 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Wow, Thanks humdingaling,
I'm trying to learn formulas and I was trying different functions to achieve what you did in data validation. I really appreciate very much your help on this.
Regards Treecko
not a problem
that link goes into more detail on various combinations you can try =)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks