Looking to create dependent dropdowns

[shophoney]

Hi,

I have an excel sheet that need to look for values in a table.

I want to select from a dropdown a BRAND, then when I select the BRAND I want a unique list of all the models for that BRAND. Then select a MODEL and have the next dropdown have a list of all the SIZES...

First picture is the tab with the dropdowns.

Next picture is the table to select the data from.
My dropdown from BRAND works not for anything else.
=OFFSET(BRAND,MATCH(A6,BRAND,0),4,COUNTIF(BRAND,A6),1)
I have created named ranges. But not sure if that's correct.

 

[zero269]

I used this video awhile back to create a couple of dependent drop-down lists.
Maybe you'll find it useful.

 

[shophoney]

Thanks I saw that series of videos.

My issues is the second dropdown item I'm looking for MODEL will appear in the list many times as it comes in many sizes and colours. The second argument exists going down and not accross.

I hope this is clear. now.

Best