+ Reply to Thread
Results 1 to 6 of 6

INDEX with 3 MATCH criteria - please help!

  1. #1
    Registered User
    Join Date
    08-14-2017
    Location
    London, England
    MS-Off Ver
    Mac Excel 2016
    Posts
    2

    INDEX with 3 MATCH criteria - please help!

    ----------------------------------
    Last edited by Carl_Spackler; 08-14-2017 at 09:49 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,213

    Re: INDEX with 3 MATCH criteria - please help!

    It's a bit ugly, 'cos of the data layout (much easier with one block of data, rather than 4). However:

    =INDEX($D$7:$AC$9,MATCH(C12,$C$7:$C$9,0),MATCH(E12,$C$5:$AB$5,0)+MATCH(D12,$D$6:$H$6,0)-1)
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,213

    Re: INDEX with 3 MATCH criteria - please help!

    Very odd.... The OP edited the problem out!!!

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: INDEX with 3 MATCH criteria - please help!

    @Carl_Spackler

    Please repost your question, in behave of other forummembers.

    With no information (question) the offered solutions of Glenn Kennedy is useless.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,213

    Re: INDEX with 3 MATCH criteria - please help!

    Who knows oeldere, even with the info; maybe my effort is useless!!!

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: INDEX with 3 MATCH criteria - please help!

    @Glenn Kennedy

    Who knows oeldere, even with the info; maybe my effort is useless!!!
    I did not seen the question or the excel file, but I doubt that.

+ 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. Single Criteria Index Match with concatenated criteria NOT WORKING
    By hassanleo1987 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 04-26-2017, 12:28 AM
  2. Need help in Index, Match usage to match multiple criteria in sum function
    By Summer0830 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2017, 02:47 AM
  3. VBA Code for Index/Match/Match to input into excel based on 2 criteria inside form
    By Carl Fisher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2017, 12:11 PM
  4. [SOLVED] Index and Two Match Criteria- meeting both criteria (need help to repair formula)
    By OilAndGasMan1984 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2017, 10:56 PM
  5. [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
  6. Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  7. Replies: 6
    Last Post: 04-30-2014, 02:42 AM

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