Match results from 3 criteria, from Row and Columns

[Pasadu]

Sir, Please I want the results to be displayed when the criteria are selected from the drop-down list. Thank you in advance.

 

[AliGW]

Which version of Excel are you using?

 

[Pasadu]

Which version of Excel are you using?

Microsoft office professional plus 2016

 

[Juniad]

Enter this formula in AZ7 with key combination Ctrl + Shift + Enter
=IFERROR(INDEX($C$2:$Y$66,MATCH(1,($A$2:$A$66=AZ3)*($B$2:$B$66=AZ4),0),MATCH(AZ5,$C$1:$Y$1,0)+1),"Record Not Found")

 

[Pasadu]

Enter this formula in AZ7 with key combination Ctrl + Shift + Enter
=IFERROR(INDEX($C$2:$Y$66,MATCH(1,($A$2:$A$66=AZ3)*($B$2:$B$66=AZ4),0),MATCH(AZ5,$C$1:$Y$1,0)+1),"Record Not Found")

Thank You Sir