+ Reply to Thread
Results 1 to 3 of 3

Need Index match formula based on two conditions

  1. #1
    Forum Contributor
    Join Date
    07-06-2009
    Location
    London, England
    MS-Off Ver
    Microsoft 365
    Posts
    184

    Need Index match formula based on two conditions

    Hi,
    See attached example.
    I would like Excel to lookup a column of values based on two conditions (date and scheme) and return a sum based on the month.
    I've done a bit of reading on this. Seems SUMIF can be used with Index and match - other posts suggest SUMPRODUCT.
    Can someone help with the formula?

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Need Index match formula based on two conditions

    Try with SUMPRODUCT
    Use in B2 and copy down and forward
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-06-2009
    Location
    London, England
    MS-Off Ver
    Microsoft 365
    Posts
    184

    Re: Need Index match formula based on two conditions

    Perfect José - worked first time. Thanks

+ 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 and Match with if statement based on multiple conditions
    By mpost54 in forum Excel General
    Replies: 4
    Last Post: 06-01-2019, 11:51 PM
  2. Excel index-match ignore criteria based on conditions
    By ironfelix717 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-18-2017, 06:44 PM
  3. [SOLVED] Match and index formula to be used to get the figure from array by meeting 3 conditions
    By srinivastsc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-19-2017, 10:26 AM
  4. [SOLVED] Formula to find 2nd Match using Index and 2 Match conditions
    By Cra5h in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-24-2016, 11:52 AM
  5. [SOLVED] INDEX MATCH based on two Field Conditions
    By naveeddil in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-08-2016, 01:09 AM
  6. Help with Index/Match Formula-two conditions and return multiple items
    By bigermac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-08-2015, 11:06 AM
  7. IF formula with multiple conditions using INDEX/MATCH
    By cad1llac in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-05-2013, 06:32 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