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.
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.
Circumference of a circle = 2πr²
²the circle's radius