Dynamic Filter drop down set up but can't get it to change after initial selection made

[JackDanIce]

Hi,

I have a normalised table in sheet Settings with headers Brand, Product, Quantity
Table is named tbl_Product.
Next to this table I have two formulae:

=SORT(UNIQUE(INDEX((tbl_Product[Brand]),,1)))
=IFERROR(FILTER(tbl_Product[SKU],'Contract Calculator (2)'!A9=tbl_Product[Brand]),"")

These cells are named Select_Brand and Select Product respectively

On sheet Contract Calculator (2), in column A, starting in row 9, I have a drop-down list with formula:

[CODE=xls]=Select_Brand#

[/CODE]
And in column B, drop-down list formula is:

[CODE=xls]=Select_Product#

[/CODE]

However, part in blue above is anchored to cell A9 so when this cell is copied to rows below, I can change the band, but the product in column B still references the brand selected in A9

I could use a worksheet event to detect cell change and update the part in blue but I'd prefer to avoid using any VBA.

Can anyone suggest a non-VBA solution to this?

TIA,
Jack