I am attempting to create a sheet for my wife that will reference classes completed, grades, and credits earned for her high school students. I am stuck at getting the class lists to populate in the order desired. I want the formula to reference the Student Name (which changes with a data validation drop down list) and the Department (i.e. English, Math, etc.) and give the results in 4-6 rows under each department listing. I have used an INDEX SMALL IF formula to return results based on 1 criteria, but cannot figure out how to get it to return results based on 2 criteria. Below is the formula I am trying to use, but Excel says there is a problem with my formula:
=INDEX(Sheet6!$A$1:$G$1531,SMALL(IF(Sheet6!$A:$A=$H$4,ROW(Sheet6!$A:$A)),ROW(1:1))*(IF(Sheet6!$C:$C=Sheet8!$D$4,ROW(Sheet6!$C:$C)),ROW(1:1))-1,2)
I have tried it with and without the second "IF" included.
Thanks in advance for any help provided!!
Bookmarks