+ Reply to Thread
Results 1 to 4 of 4

Pivot Table Lookup

Hybrid View

  1. #1
    Registered User
    Join Date
    03-22-2019
    Location
    UK
    MS-Off Ver
    2013
    Posts
    10

    Re: Pivot Table Lookup

    As you can see this is the Pivot - no data is given that means anything.
    When I add AccName it appears under the (+) but I need to add it as a separate column. When I try to do this is tries to make it a calculation (avg, sum, etc) - how can I add a AccName column (existing field) that just shows the field data for that record in a column or even link to that column.

    Bottom line is that I need to show the AccName based on a search on the Account (top) and Date. I was going to use VLOOKUP to do this task but without the AccName coumn I cannot figure it out.

    Capture.PNG
    Last edited by NMansell; 03-28-2019 at 04:35 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using pivot table to lookup data from large table, but would like to edit
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2017, 12:29 PM
  2. lookup / pivot table help
    By davsco8 in forum Excel General
    Replies: 0
    Last Post: 10-28-2014, 04:42 PM
  3. [SOLVED] Value error when using lookup with a pivot table
    By Pickygame in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-09-2013, 05:53 AM
  4. [SOLVED] V-lookup in Pivot Table
    By kisboros in forum Excel General
    Replies: 6
    Last Post: 04-18-2012, 11:02 AM
  5. Replies: 0
    Last Post: 08-02-2005, 01:05 AM
  6. Pivot Table Lookup
    By Robert_L. in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2005, 09:10 PM
  7. Can I use a 'lookup' to a Pivot Table?
    By Chrism in forum Excel General
    Replies: 1
    Last Post: 04-07-2005, 02:06 PM

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