Need urgent help.

[Supertramp]

[#2]

Column D as in Course name

[#3]

@Supertramp 

You may use something like

=INDEX(COLUMN D,
 MATCH(1,INDEX( (ColumnC=Name)*(ColumnA = Date),0),0)
)