I guess the Brand Detail represents your Brand bought. The Brand Considered on different rows could have Bosch but the Brand Bought could be different.
But your formula looks to use Brand Detail on the row to compare the Brand Considered as well which may not get you the result you want.
The Brand has to be indepedent and the compute Brand Bought and Brand Considered indepently and then match with the brand list.
This video should help you get an idea on how to approach this issue
Regards,
Giri
Regards,
Giri