Hi,
I created a template with dependent drop down lists.I hope it will be useful for users.
The database includes products, product categories, suppliers of products and prices. Even if the data in the table is mixed, we can comfortably examine the products by grouping them by category and suppliers on linked drop-down lists , the data can be entered to other sheets.
Source