Index + Match not working :(

1. 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.

2. Re: Index + Match not working :(

Try

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

3. 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.

4. Re: Index + Match not working :(

Is this it?

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

5. 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. Re: Index + Match not working :(

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

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