CountIf & Vlookup Combinatoin

[sc0ttish]

Hello everyone,

I've trying to set up a formula, which i thought would be easy but seem to be stuck.

My spreadsheet has two worksheets House List & Brandcount

House List has the account number in column C and the account number in the Brandcount is in column A.
In the Brandcount worksheet in column B is a list of brands purchased (Brand 1, Brand 2, Brand 3, Brand 4, Brand 5)

What i wanted to do is in House List is in column F count the brands purchased by each account number, is:
Account 12345 , 3 brands

I've tried using a combination of countif and vlookup but not getting far.

Can someone point me in the right direction.
Thanks

 

[sc0ttish]

How about

=IF(C2="","",IFERROR(ROWS(UNIQUE(FILTER($B$11:$B$200,$A$11:$A$200=C2))),0))

Awesome stuff. thanks very much

 

[Fluff]

You're welcome & thanks for the feedback.