I know you would normally use a pivot table for this but i am trying to add
this to a master sheet.

Customer Sheet (static sheet)
Column A Column B Column C
list of all customers Jan Feb

Commissions (sorted by date sold...refreshable)
Column A Column B Column C
list of customers Date Sold Margin

I want to do a check from Customer to Commission on the customer..if they
equal then i want to add all the product margin for January and dump it into
Customer!:B2.

Commissions only shows for 2005 so I am not trying to pull year over year.

Thank you for any help that can be given. PETE