lookup / pivot table help

Help Please!

I have a column list of let's say 10 product numbers (so product # 1 thru 10 in column A) and the quantity of each we have in inventory in column B, and then i have a sheet/tab that has records of all our let's say 200 customers purchases of these various products. So customer 3 bought 5 of item 4 and 7 of item 8; customer 125 bought 25 of item 8 and 12 of item 10; etc.

By each of the 10 products on the list, i want to show which customer bought the most and how much they bought.

I can create a pivot table that has product numbers in a column and customers going across, with the sum of each product in the various grid cells. So i know how much of each product each customer bought.

But is there some sort of lookup and/or getpivotdata formula i can use that will find the largest customer for each product and drop that customer in beside the product number along with the volume they purchased?

thanks!!!