Excel categories and subcategories

[Practicart]

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

[#2 · Accepted solution]

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.

[#3 · Accepted solution]

If you find the above solution resolved your query don't forget mark as Official Answer.