PDA

View Full Version : Use Pivot Table Data in Formula with multilpe criteria



aubxv000
2011-12-08, 06:23 AM
383

I have a range of data that I have converted into a pivot table with subtotals (Region, Code, and Subtotal of Region Codes).

I am trying now to use a formula (perhaps Vlookup) to pull this data from my pivot table and display in another data spreadsheet with 2 matching criteria.

Bascially in english:

IF(DATASHEET! A2 = PIVOT TABLE! REGION + DATASHEET! B2 = PIVOT TABLE! CODE ) show PIVOT TABLE! Subtotal REGION CODE if True, 0 if False)

A condensed spreadhsheet is attached to make more sense of this.

thankyou!

JoePublic
2011-12-08, 02:04 PM
You can use GETPIVOTDATA for that. In C2:
=IFERROR(GETPIVOTDATA("Region Code Total",'Pivot Table'!$A$1,"Region",A2,"Code",B2),0)
and copy down.