If I use the below array formula in cell then it's working fine
=IFERROR(INDEX(Data!$D$2:$P$25,MATCH(1,(Data!$A$2:$A$25='Controls & Checks'!$O$27)*(Data!$B$2:$B$25=('Controls & Checks'!$O$28*1))*(Data!$C$2:$C$25=[@Advisor]),0),COLUMN(A$1)),"")
But it's not working when I try to use in VBA code with Evaluate function which returns #VALUE Error
Cells(11, i).Value = Evaluate("=IFERROR(INDEX(Data!$D$2:$P$25,MATCH(1,(Data!$A$2:$A$25='Controls & Checks'!$O$27)*(Data!$B$2:$B$25=('Controls & Checks'!$O$28*1))*(Data!$C$2:$C$25=[@Advisor]),0),COLUMN(A$1)),"""")")
I am unable to fix what is going wrong