Populating info from pivot table

**extrudebg** · 05-01-2012, 11:37 AM

I am having trouble figuring out how to associate the results of a sum from a pivot table back to the original source sheet when 2 cells need to match. I have attached a simplified version of a spreadsheet as an example. On the "source" sheet, I need to populate the sum from the "pivot" sheet in column "D".

For example, for cells D2-D5 (that have Column A = Austin and Column B = 1), I need to associate to cell B5 from the pivot. For cells D6-D9 (that have Column A = Austin and Column B = 2), I need to associate to B6 from the pivot, etc...

Any assistance is appreciated.

**NBVC** · 05-01-2012, 11:46 AM

How about instead of using the Pivot Table, you just use a formula that sums on those conditions...

e.g.. in D2 enter:

=SUMIFS(C:C,A:A,A2,B:B,B2)

and copy formula down the column.

**JieJenn** · 05-01-2012, 11:48 AM

You might want to change the pivot table layout to make it like a lookup table format. In Source D2, enter the formula =INDEX(Pivot!$G$3:$G$21,MATCH(A2&B2,Pivot!$E$3:$E$21&Pivot!$F$3:$F$21,0)) with ctrl + shift + enter since it is an array formula