Results 1 to 2 of 2

Thread: Use Pivot Table Data in Formula with multilpe criteria

  1. #1

    Exclamation Use Pivot Table Data in Formula with multilpe criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

  2. #2
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    170
    Articles
    0
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •