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