Forum Discussion
Excel categories and subcategories
I want to make a dropdown list to excel with categories and subcategories, for keep tracking the items of a storehouse.
The first column is with different categories and the second one with subcategories. I whould like when choose a category from the dropdown list of the first column to appear on the next column subcategories related with the chosen category. Is it possible?
Thank you
HI Practicart
This blog might be helpful for your if you are using Office365
https://excelexciting.com/how-to-make-dependent-dropdown-list-with-xlookup/
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer.
1 Reply
HI Practicart
This blog might be helpful for your if you are using Office365
https://excelexciting.com/how-to-make-dependent-dropdown-list-with-xlookup/
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer.