+ Reply to Thread
Results 1 to 4 of 4

Can't Get Excel To return data based on 2 criterion from Pivot Table

  1. #1
    Registered User
    Join Date
    07-26-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Can't Get Excel To return data based on 2 criterion from Pivot Table

    I have a question when it comes to looking up a value on a pivot table based on two criteria. I've searched this and other forums but no formula seems to be working for(nor does any macro or coding).
    I need to be able to look up the daily usage amount for an account based on the account and date. The daily usage is in a pivot table where the dates are going across and the accounts are going down(x&y basically). I've tried index match functions, getpivotdata, vlookups and hlookups. They seem to return the wrong data. I also need to multiply the daily usage by the price up top but that i know can be done simply afterwards so if you could at least help in finding a formula that gives me the correct data for each cell it would be greatly appreciated.

    Thanks!
    Last edited by thecuteonexoxo; 07-27-2012 at 02:09 PM. Reason: Forgot Attachment (:

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Can't Get Excel To return data based on 2 criterion from Pivot Table

    in b8
    =GETPIVOTDATA("Sum Of Daily",'Usage By Account'!$A$3,"Account Numbers",$A8,"Date",B$5)
    and fill as required
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    07-26-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Can't Get Excel To return data based on 2 criterion from Pivot Table

    THANKYOUTHANKYOU! .. I knew it was so simple but for some reason when i typed that myself it kept giving me #REF! errors

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Can't Get Excel To return data based on 2 criterion from Pivot Table

    you're welcome :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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