Trying to create multiple Sumproducts

I have two spreadsheets, one that lists clients and their adviser along with their service proposition and one that details the clients and the funds they have. I am trying to look up all the clients on a certain service proposition and return all the appropriate funds.

It is very difficult to explain but I have attached a trial workbook!

Any help would be much appreciated!!

Many thanks in advance!!

Alex

I am still trying to get my hear around this......

Basically, the client ref is the only common column in both spreadsheets so I am trying to basically create a sumproduct in one spreadsheet to return all the client ref's that match data but then use the client ref's to match in the next spreadsheet to return values????