+ Reply to Thread
Results 1 to 3 of 3

Using VLookup on Pivot Table

  1. #1
    Registered User
    Join Date
    02-25-2010
    Location
    Washington State
    MS-Off Ver
    Excel 2007
    Posts
    5

    Using VLookup on Pivot Table

    I have a very simple pivot table that I am trying to use as a data source for a VLOOKUP request. Unfortunately, every time I do it I get the result #NA. I have tried recreating the results from the pivot table in the worksheet next to it, and am able to use VLOOKUP on them successfully, but as soon as I point the VLOOKUP array to the pivot table, I get the #NA result

    Can VLOOKUP be used on pivot tables? If so, is there any special syntax I need to use?

    Thanks

  2. #2
    Registered User
    Join Date
    07-07-2009
    Location
    Orange County, California
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Using VLookup on Pivot Table

    yes, just be sure the source & the lookup value is as same. (option: the vlookup range "outside" the pivot table. for example, the pivot table is from a2..to m100, do the vlookup range from a1 to m101)

  3. #3
    Registered User
    Join Date
    02-25-2010
    Location
    Washington State
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Using VLookup on Pivot Table

    I played around with it as soon as I made this post, and somehow was able to get it working. Can't really tell what I did different, but I'm now able to vlookup from a pivot table.

    The Gremlins must've stopped monkeying with my code when I wasn't looking.

    Thanks for your response.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1