OK .. so I have this formula and it works flawlessly. Except for the fact that it is an array and it's apart of my macro and I have to manually make it an array for it to work. I have over 40 pages that I would have to manually go do so that's not gonna work for me. I know there's away to get it to do it with like a vlookup maybe but I cannot get it to work. So here's what my formula is:
=INDEX(Updated!$E$2:$E$667,MATCH($A$1,IF(Updated!$B$2:$B$667=B2,Updated!$A$2:$A$667,),0))
Basically I have multiple students who take multiple tests. I want to find the score for a particular test based on the students name.
A1 contains the students name
B2 contains the course list
Updated!B2:b667 has all the courses
Updated!A2:A667 has all the students names
Updated!E2:E667 has all the scores
Any help would be appreciated.
Bookmarks