Return single value out of several matching values

[SalmanKS]

Hi Everyone!
I need help to get single value out of multiple matching values (criteria: if Name, Reg. No & Class are same then get values under Month & Amount). Attaching a sample file.
Sample.gif

[SalmanKS]

Sorry... I was unable to attach an Excel file. Beg my pardon.

[kvsrinivasamurthy]

In K2, copied up to column M

=IFERROR(INDEX(A$2:A$7,AGGREGATE(15,6,ROW($A$2:$A$7)/(ISERROR(MATCH($A$2:$A$7&$B$2:$B$7&$C$2:$C$7,$K$1:$K1&$L$1:$L1&$M$1:$M1,0))),1)-ROW($A$1)),"")

In N2

=TEXTJOIN(", ",TRUE,IF(($A$2:$A$7=$K2)*($B$2:$B$7=$L2)*($C$2:$C$7=$M2),$D$2:$D$7,""))

In O2

=IF(K2="","",SUMIFS($E$2:$E$7,$A$2:$A$7,$K2,$B$2:$B$7,$L2,$C$2:$C$7,$M2))

[SalmanKS]

Thank you so much for your dedicated concern. All the fields are working good except "m column". It returns #NAME? even in the downloaded sheet. If it could be fixed, it will be marvelous .