I have a formula that looks up the completion date of a course someone took. I want to add a fourth criteria so we can use this Course Entry Table for years to come. Can someone show me how to do this?
My Entry table has 4 columns: Date, Name, Course, Pass_Fail
My Completion Log has all of the names down the left side and all of the courses across the top. Some courses are mandatory every year and some are electives that are taken maybe once in a career.
I want to be able to put a year in a cell at the top of the page and show the completion dates for all of the students for that year.
Criteria I need to add:
YEAR(Date)=E32
Current Formula that works with named ranges:
=IFERROR(INDEX(Date,MATCH($B34&C$33&"Pass",INDEX(Name&Course&Pass_Fail,),0)),"")
My Entry table has 4 columns: Date, Name, Course, Pass_Fail
My Completion Log has all of the names down the left side and all of the courses across the top. Some courses are mandatory every year and some are electives that are taken maybe once in a career.
I want to be able to put a year in a cell at the top of the page and show the completion dates for all of the students for that year.
Criteria I need to add:
YEAR(Date)=E32
Current Formula that works with named ranges:
=IFERROR(INDEX(Date,MATCH($B34&C$33&"Pass",INDEX(Name&Course&Pass_Fail,),0)),"")
