agwalsh
asked on
dependent validation list using only the first 2 characters...possible in Excel or not?
I can set up a dependent dropdown validation list using Indirect..named ranges etc. However, is it possible to do the following..
in the attached file I have a list of 4 digit codes that starts with 52, then another that starts with 50. Is it possible to set up a dependent dropdown list that is set up so that when the user enters a code starting with 52 in one cell, that on the same row in a column beside it, a list is generated which only shows the descriptions and numbers for the codes starting with that e.g. in the attached file it should only show the entries in rows B1:B20.(in blue) Then if the user selects a number that starts with 50, they should only see the entries in B21:B27 (yellow).
Thanks
EE-dependent-dropdown-list---first-.xlsx
in the attached file I have a list of 4 digit codes that starts with 52, then another that starts with 50. Is it possible to set up a dependent dropdown list that is set up so that when the user enters a code starting with 52 in one cell, that on the same row in a column beside it, a list is generated which only shows the descriptions and numbers for the codes starting with that e.g. in the attached file it should only show the entries in rows B1:B20.(in blue) Then if the user selects a number that starts with 50, they should only see the entries in B21:B27 (yellow).
Thanks
EE-dependent-dropdown-list---first-.xlsx
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
That is what the selection in A1 does. The drop down lists in col. A and B are dependent upon the selection in A1.
ASKER
I know that and I can see that. But what the user wants is a scenario where the following happens.
She has set up a vlookup that autopopulates with the 4 digit codes. Then the users are to apply a sector to it e.g. 5000 narrows it down to the description of the codes that starts with 50 but in your solution they would have to pick 50 or 52 from the list...
She has set up a vlookup that autopopulates with the 4 digit codes. Then the users are to apply a sector to it e.g. 5000 narrows it down to the description of the codes that starts with 50 but in your solution they would have to pick 50 or 52 from the list...
Can you upload a sample workbook with the same layout as of your original workbook with all the formulas in place and highlight the cells where you want the drop down lists and then explain your logic based on the sample workbook?
agwalsh,
If I understand your request correctly, you would like to see an "Intellisense-like" feature like seen in table filters. The function behaves as a real-time filter that shows valid values that have sub-string matching of entered values.
What I'm not quite understanding is why a user would have to enter all four digits just to see the other codes that have the same first two.
-Glenn
If I understand your request correctly, you would like to see an "Intellisense-like" feature like seen in table filters. The function behaves as a real-time filter that shows valid values that have sub-string matching of entered values.
What I'm not quite understanding is why a user would have to enter all four digits just to see the other codes that have the same first two.
-Glenn
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I have recommended this question be closed as follows:
Split:
-- Subodh Tiwari (Neeraj) (https:#a41768377)
-- Glenn Ray (https:#a41771081)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
frankhelk
Experts-Exchange Cleanup Volunteer
I have recommended this question be closed as follows:
Split:
-- Subodh Tiwari (Neeraj) (https:#a41768377)
-- Glenn Ray (https:#a41771081)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
frankhelk
Experts-Exchange Cleanup Volunteer
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER