Find the value as per 4 criteria

[Bibhuti Mohanty]

Dear Expert,

I need some assistance for solve some issue on working sheet. I have to found the basic amount as criteria given on my sheet.

Thanks & Regards,

Bibhuti

 

[Hui]

C49: =MAX(IF($A$2:$A$45=A49,$C$2:$C$45)) Ctrl+Shift+Enter
D49: =INDEX($D$2:$D$45,MATCH(C49,$C$2:$C$45,0),)
E49: =INDEX($E$2:$E$45,MATCH(C49,$C$2:$C$45,0),)
F49: =INDEX($F$2:$F$45,MATCH(C49,$C$2:$C$45,0),)
Copy all down