Dear Members,
Referring to the drop down list in Column B, unable to select any Branch whenever I choose State "Uttar Pradesh" under Column A.
Please suggest.
Regards,
Akash Sharma
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Dependent Drop Down List issue
0
Answers
0
Selected Answer
Akash
Put "Uttar_Pradesh" in cell C5 (with the two words separated by an underscore not a space) and it will work.
The problem was that you have named a range as "Uttar_Pradesh" but the data validation for cell A2 uses the List from A5:C5 where C5 is "Utar Pradesh" (with a space, not an underscore) so the name isn't recognised and the INDIRECT function will not work. Check in Formulas/Name Manager to see the named ranges (Note that spaces are NOT allowed in Names)
You can use spaces in dropdown lists if you use the table-based solution for dependent dropdowns- see Don's tutorial Automatically Updating Dependent Drop Down List Menus in Excel.
Hope this helps.
Discussion
Wow amazing awesome. Thanks, it works when using the underscore.
Akash Sharma (rep: 40) Dec 23, '20 at 10:04 am
Glad it works. Check out Don's tutorial for a good solution with spaces.
Enjoy the holiday season!
Enjoy the holiday season!
John_Ru (rep: 6142) Dec 23, '20 at 10:14 am