Index/Match multiple criteria and results

[CindyCas]

I have a list of skill exams taken by a large number of students. Student can retake different versions of the exam multiple times in preparation for their licensure, but each attempt has the same name. I am trying to take that list and create a large table that compares student grades with scores on these exams to include all attempts. I have everything set except for the multiple attempts of the same exam.

I am using match/index to find the exam in the table and return the score and level. However, I need to be able to list each attempt for the student.

the first table is a small list showing 1 student with 4 attempts at 1 exam. Below is a snapshot of just the section I am currently working on in the student table I am creating. These are on 2 worksheets in the same workbook.

The formula I am using to pull the results is: =IFERROR(INDEX(ATI[Adjusted Score],MATCH(1,([@COMP]=ATI[Course])*([@ID]=ATI[Student ID]),0))," ")

 

[Fluff]

Can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[CindyCas]

Can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Since my document has student specific information, I can't post a sample of it.

 

[Fluff]

But you can post the sample used in the image.