Forum Discussion

Copper Contributor

Mar 20, 2020

Solved

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 subcateg...

excel

ExcelExciting
Mar 20, 2020
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.

ExcelExciting

MVP

Mar 20, 2020

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.