Excel validation with if

Hello, i want some help in excel:
I have column A - Brands (about 10 different)
In Column B - types of products of the brands (200 different)
In cilumn C - price of products.

Is there a way to have a data validation in another tab:
Choose in A1: Brand (ok this is straight forward)
Then depending what i chose in A1, to have in B1, only the types of product for that brand as a drop down list?

Thanks!