Help with formula from Pivot Table
Results 1 to 2 of 2

Thread: Help with formula from Pivot Table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help with formula from Pivot Table

    Hi everyone,

    It would be highly appreciated, if someone could help me with the following:

    Letīs say I have a product code 2310 that I want to lookup on a Pivot Table, and to return the value on Column C.

    The issue is that under the code 2310 (on the pivot table), I have two other options that I want to lookup for (Available and Not Available). So, what I want, is to retrieve the value on Column C, for the Available and Not available under the code 2310.

    If someone could help me it would be amazing!

    Many thanks and regards

  2. #2
    MrExcel MVP FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    6,063
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Help with formula from Pivot Table

    Hi, if, in the cell where you want the formula, you press = and then select the value in the pivot table that you want to retrieve does Excel create a GETPIVOTDATA() function for you?
    [code]your code[/code]

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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