Pull sub-test scores from test w/best overall test score (PSAT)

[PowerSchoolDude]

Hello!

So I'm trying to work on this test score report and I can't seem to figure out how to do the following:

- Currently I'm pulling test scores, but I'm getting only the highest scores for each section. What's I'm trying to pull are the sections scores from the test with the highest overall score. Several students have taken the PSATs more than once and I would like the scores from just one test date.

I was thinking of using INDEX(MATCH(MAX), but I couldn't get anything to work.

I've attached the spreadsheet I've been working on in hopes that maybe someone knows how I can do this. I know it might be a bit confusing, but I think seeing the workbook might help.


Thanks!