Referencing list Of 10 Customers By Sales Value For A Prodcut

Hi All,

Could someone please advise what is the right formula for me to achieve my objectives here.

From the raw data I have 3 columns,

A for customers

B for products

C for sales

I would like by selecting a product in columns B to be able to reference to a new sheet a list of the top 10 customers by sales value for this product, so excel need to find the top 10 list of customers purchased this product in column A and this filter them by top 10 based on sales value in column C.

I want this list to be in a new sheet and without pivots.

So from in the new sheet I have drop list of all prodcut by selecting a product and want then below to be able to see the top 10 customers by sales for this product.

So which formula I should use here?

I tried the below, but it give me only a drop down list, I want to be able to see the top 10 customer listed separately in each cell under one column! 

=OFFSET($A$5,MATCH($D$2,B:B,0),0,COUNTIF($B:$B,$D$2))

Thanks in advance!!