+ Reply to Thread
Results 1 to 7 of 7

Only getting the first index match result

  1. #1
    Registered User
    Join Date
    01-06-2021
    Location
    Spain
    MS-Off Ver
    2016
    Posts
    3

    Only getting the first index match result

    Hello everyone,

    I'm trying to create a student schedule that automatically puts in the hour for each student. I managed to get the result for everyone but I'm having difficulties getting the hour for the students that have class more than 1 day a week. I have uploaded the file so that you can see what I've done and what I'm missing.
    Appreciate all the help.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Only getting the first index match result

    Hi
    Please try this at H12 and across:
    =IFERROR(INDEX(Data!$E$1:$E$17,MATCH(Schedule!$D12&Schedule!H$5,Data!$B$1:$B$17&Data!$C$1:$C$17,0)),"")
    Attached Files Attached Files
    Last edited by Limor_OP; 01-06-2021 at 04:30 PM.

  3. #3
    Registered User
    Join Date
    01-06-2021
    Location
    Spain
    MS-Off Ver
    2016
    Posts
    3

    Re: Only getting the first index match result

    Quote Originally Posted by belinda200 View Post
    Hi
    Please try this at H12 and across:
    =IFERROR(INDEX(Data!$E$1:$E$17,MATCH(Schedule!$D12&Schedule!H$5,Data!$B$1:$B$17&Data!$C$1:$C$17,0)),"")
    Hi Belinda,
    I tried putting that but it doesn't show any of the times for that person's row.

  4. #4
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Only getting the first index match result

    Look at the attachment I added to my post....

  5. #5
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070

    Re: Only getting the first index match result

    In your worksheet, you should be using an Array Formula ...

    i.e. instead of the Enter key, use simultaneously the three keys : Alt Control Enter
    HTH
    Carim


    Top Excel Links

  6. #6
    Registered User
    Join Date
    01-06-2021
    Location
    Spain
    MS-Off Ver
    2016
    Posts
    3

    Re: Only getting the first index match result

    Thank you Belinda for the answer and Carim for the clarification. Shows exactly what I needed.

  7. #7
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070

    Re: Only getting the first index match result

    De nada ... you are welcome

    Glad you could fix your problem

+ 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 more than 1 result available but only displaying the 1st result
    By MarkPr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2018, 04:48 AM
  2. [SOLVED] index match , 0 instead of N/A when no result
    By muss1210 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-22-2017, 01:02 PM
  3. [SOLVED] INDEX/MATCH generates incorrect result by referencng nearest cell if match not found
    By aglawrence in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-29-2017, 08:59 AM
  4. [SOLVED] Index/Match - More than 1 Result
    By LJenny in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 10-13-2015, 11:08 AM
  5. [SOLVED] Index/Match result should again search for zero result
    By ursanil in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2014, 04:45 AM
  6. index match, ..... skip result if blank value ...... jump to next match
    By gehawk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2013, 04:42 AM
  7. [SOLVED] Index Match if result is not something
    By Jaron_t in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-19-2012, 01:19 PM

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