LinkBack URL
About LinkBacks
Hi guys, i want to make a list that gives me values dependant on what has been selected in another list but do not know how to do it. I have attached a copy of the spreadsheet containing the values I want to use
Hi guys, i want to make a list that gives me values dependant on what has been selected in another list but do not know how to do it. I have attached a copy of the spreadsheet containing the values I want to use
This is a very common request.
Here are thee tutorials:
https://www.excel-easy.com/examples/...own-lists.html
https://trumpexcel.com/dependent-dro...list-in-excel/
https://www.contextures.com/xlDataVal02.html
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you for your reply. Ive got it working but there a a few issues. Firstly it wouldnt let me name my columns using numbers so I have had to write them and secondly because each diameter had a different number of allowed thickness so blank spaces have been included in the drop down list. Is there a way to get round these things?
At this point, please provide a new version of your workbook showing where you have got to so far.
Ive attached the workbook
In the Name Manager, adjust the ranges used for each list to limit them to just the entries available.
For example, the range for Fifty should be: =Sheet1!$H$3:$H$5
Thank you, ive sorted out the ranges and removed the blank cells. Is here a way of making the names in the first box numbers? I tried changing it on the name manager but that didnt work.
Yes, there is.
Change the validation list in D12 to this:
=$A$3:$A$8
and the one in E12 to this:
=INDIRECT(INDEX($C$2:$H$2,,MATCH(D12,$A$3:$A$8,0)))
Thankyou, thats perfect
Yup!
Of course, it relies on the layout you have. Should that change, you will need to amend the ranges in the INDEX MATCH function, as they will not automatically change.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks