=MAX(     )
       ^
       |
       IF('disciplinary action data'!A$2:A$10=$A2,       )
                                                       ^	
                                                       |
                                                       IF( 'disciplinary action data'!C$2:C$10="Absent",'disciplinary action data'!B$2:B$10 )