I have been using below formula with enabling the Arrays and convert it into VBA code like this below code.
When the code paste that formula into the given cells it has locked the Cell A10 which should be changed accordingly with cell reference.
Any help will be appreciated.
Code
=IFERROR(INDEX(Table1!$A$1:$DP$27,MATCH($G$9&$E$4,Table1!$E:$E&Table1!$F:$F,0),MATCH(A10,Table1!$6:$6,0)), "")