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!
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!