+ Reply to Thread
Results 1 to 6 of 6

Index/Match Difficulties

  1. #1
    Registered User
    Join Date
    10-13-2021
    Location
    Durham, NC
    MS-Off Ver
    2109
    Posts
    3

    Index/Match Difficulties

    Hello!

    I'm having some difficulties with using index/match to solve this problem. On my sample workbook - I need to retrieve the summed values for each month (in the raw data - tab 2) and enter them into my first tab under the appropriate date. I'm using the dates and/or the unique identifier in order to match these. Would anyone be able to assist?
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Index/Match Difficulties

    You can use this formula in cell C2 of Sheet1:

    =SUMIFS(Table2[Amount],Table2[Customer Name],$B2,Table2[Invoice Date],C$1)

    then copy across and down as required.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    10-13-2021
    Location
    Durham, NC
    MS-Off Ver
    2109
    Posts
    3

    Re: Index/Match Difficulties

    That is exactly what I was hoping to do, thank you so much!

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Index/Match Difficulties

    In C2:
    Please Login or Register  to view this content.
    copied down and across
    Attached Files Attached Files
    Ben Van Johnson

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Index/Match Difficulties

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

  6. #6
    Registered User
    Join Date
    10-13-2021
    Location
    Durham, NC
    MS-Off Ver
    2109
    Posts
    3

    Re: Index/Match Difficulties

    Will do! I appreciate the help, this saved me a ton of time.

+ 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] INDEX+MATCH instead of VLOOKUP+MATCH, why is INDEX a better choice and how to re-write?
    By Renejorgensen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2016, 10:54 AM
  2. [SOLVED] Index / Match - match 3 input values and return the results from the index
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2016, 07:34 PM
  3. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  4. INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges
    By Andrew-Mark in forum Excel General
    Replies: 3
    Last Post: 02-27-2015, 10:56 PM
  5. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  6. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  7. Replies: 3
    Last Post: 05-02-2013, 01:31 AM

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