+ Reply to Thread
Results 1 to 6 of 6

Index + Match not working :(

  1. #1
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    50

    Unhappy Index + Match not working :(

    Hello I have what I think is a simple problem but I cannot figure out how to solve it.

    My spreadsheet is arranged this way:

    B5 C5 D5
    Student Name Test 1 Test 2
    Random Test Name Random Test Name

    B6 C6 D6
    Student 1 68.00 98.00

    B7 C7 D7
    Student 2 80.00 100

    This information is on a sheet named Math.

    On another sheet I am trying to display the data in the following way:

    A1 B1 C1 D1
    Name Subject Lowest Score Assignment Name

    A2 B2 C2 D2
    Student 1 Subject Name 44.00 xxxx

    I am trying to have the assignment name filled in based on the lowest score for a given student.

    The subject name is being pulled from C2 on the Math sheet.

    The lowest score has the formula =MIN(Math!C6:D6)

    The formula in D2 that I am trying to use to pull an assignment name from the lowest score is =INDEX(Math!C6:D6,MATCH(C2,Math!C5:D6,0))

    In reality I have 43 student names in the student column and 30 or sometimes more assignments across. I need to apply the formula to work on many sheets.

    Anyway I have tried several different variations of different formulas and I cannot seem to get this to work. Any help would be greatly appreciated.
    Attached Files Attached Files
    Last edited by lOYvEpi6M87nEoIF0ul8; 08-10-2017 at 12:37 PM. Reason: Attachment did not attach

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Index + Match not working :(

    Try

    =INDEX(Math!C$5:D$5,MATCH(C2,Math!C6:D6,0))

  3. #3
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    50

    Re: Index + Match not working :(

    Thank you! This works on the sample I provided but not the original. I get an NA error.

    Here is a portion of the original.
    Attached Files Attached Files

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

    Re: Index + Match not working :(

    Is this it?

    =INDEX(Math!$C$5:$AF$5,MATCH(Sheet2!E2,Math!C6:AF6,0))
    Attached Files Attached Files
    Glenn



  5. #5
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    50

    Re: Index + Match not working :(

    Yes thank you so much! It was not working because I had slightly different cells in the actual one I am using and I did not have any data entered yet -.-. I have a neurological problem that effects my concentration but I still can't believe I missed the proper references. Thank you again!

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

    Re: Index + Match not working :(

    You're welcome... IOY etc, etc....

+ 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 not working
    By kriminaal in forum Excel General
    Replies: 4
    Last Post: 11-16-2016, 09:33 AM
  2. Index Match Match - 2 x Vertical Lookups - Not working as it should
    By seash in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2016, 09:58 AM
  3. [SOLVED] help index and match macro not working but formula working??
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2016, 06:37 AM
  4. [SOLVED] Working INDEX MATCH with SEARCH, but I need to add another MATCH to the formula!
    By DaveBre in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-11-2014, 01:03 AM
  5. Correct/Working (Index,Match) formula not working between cells
    By barnerd in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-11-2014, 01:20 PM
  6. INDEX MATCH MATCH working great and then failing on me.
    By HeikEve in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-25-2013, 01:40 PM
  7. Replies: 2
    Last Post: 05-24-2013, 09:32 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