EDIT: The formula is for the data validation. The 'Brand' and 'Manufacturer' are dynamic named ranges.

The data looks like:

A 1
A 2
A 3
B 4
B 5
B 6
A 7
B 8
C 9

And so on... where the first column is the Manufacturer named range and the second column is the Brand named range.