Use Pivot Table Data in Formula with multilpe criteria

aubxv000

New member
Joined
Dec 8, 2011
Messages
1
Reaction score
0
Points
0
View attachment example.xlsx

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

Super Moderator
Staff member
Joined
Sep 16, 2011
Messages
219
Reaction score
0
Points
16
Location
UK
Excel Version(s)
2016
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.
 
Top