Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Greeley, Colorado
    Posts
    188
    Thanks
    8
    Thanked 1 Time in 1 Post

    How do I lookup data in a pivot table

    Is there a way to do this? I have a sheet that has items matching the column data in the pivot but I cannot seem to get lookup or vlookup to work.

  2. #2
    Lounger
    Join Date
    Apr 2012
    Location
    Abergavenny, Wales, UK
    Posts
    25
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Hi

    If the layout of your Pivot Table is likely to alter, then you should use GETPIVOTDATA.

    If the layout of the PT is not likely to alter then there is no reason why VLOOKUP shouldn't work, or you could use INDEX / MATCH

    The attached file shows a small set of data, a simple PT and a Lookup sheet with each of the above methods.

    Regards
    Roger Govier
    Microsoft Excel MVP
    Attached Files Attached Files

  3. The Following User Says Thank You to Roger Govier For This Useful Post:

    bdesilva (2012-04-26)

  4. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Greeley, Colorado
    Posts
    188
    Thanks
    8
    Thanked 1 Time in 1 Post
    Thanks! I'll give them all a try. Not sure why my tests didn't work last night.

  5. #4
    New Lounger
    Join Date
    Mar 2013
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Try This to Use Get Pivot with External Data look up value

    HI

    I had a similar problem and used Get Pivot

    =(GETPIVOTDATA("movment",TB_Pivot,"Master_Sub_Acco unt",TEXT(B34,"#####")))

    At the end I added Text(Lookupvalue,"####") to Convert my list as I had account numbers 5500,5600 and I wanted to look up the corresponding values from the Pivot table.



    Hope this helps

Posting Permissions

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