+ Reply to Thread
Results 1 to 6 of 6

INDEX/MATCH formula to match 3 criteria

  1. #1
    Forum Contributor garrett.grillo's Avatar
    Join Date
    06-19-2011
    Location
    San Francisco, California
    MS-Off Ver
    Excel 2010
    Posts
    188

    INDEX/MATCH formula to match 3 criteria

    I need an INDEX MATCH formula that will match 3 criteria.

    In my example that's attached, in cell A7 I cannot get this formula to work.

    Please Help...

    Thank You!
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: INDEX/MATCH formula to match 3 criteria

    something like this?
    =SUMPRODUCT(($A$12:$A$19=$A$3)*($B$12:$B$19=$B$3)*($C$11:$F$11=$C$3)*$C$12:$F$19)

  3. #3
    Forum Contributor garrett.grillo's Avatar
    Join Date
    06-19-2011
    Location
    San Francisco, California
    MS-Off Ver
    Excel 2010
    Posts
    188

    Re: INDEX/MATCH formula to match 3 criteria

    Yes!
    That works!!!
    Thank you!

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: INDEX/MATCH formula to match 3 criteria

    Glad to help

    If the basic problem is solved
    - it's always a good practice to show respect to the person(s) who have helped you
    - is a click on the Add Reputation first (left lower corner of the post of person(s) who helped you) and then
    - mark the thread as SOLVED (top right corner over your first post - Thread Tools). This is important for all of us,

    Thanks

  5. #5
    Forum Contributor garrett.grillo's Avatar
    Join Date
    06-19-2011
    Location
    San Francisco, California
    MS-Off Ver
    Excel 2010
    Posts
    188

    Re: INDEX/MATCH formula to match 3 criteria

    Now how do I mark this as solved???

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: INDEX/MATCH formula to match 3 criteria

    You marked
    Thanks for feedback

+ 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. Index/Match to Match entries on multiple criteria
    By manning457 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-06-2015, 02:32 PM
  2. [SOLVED] Combining 3 Formulas: Return all Names that Match Criteria Using Index/Match
    By bchilme in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-29-2014, 09:28 AM
  3. Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  4. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  5. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  6. Index Match based on 2 Criteria only returning 1 match
    By stsanders22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 11:26 PM
  7. Replies: 5
    Last Post: 02-29-2012, 08:51 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