HI,
i have VBA code which is working fine, however, for this line of code, the resulting formula is coming with the "@" symbol thus causing invalid results.
The resulting formula is =IF(F2=AF2,1,IFERROR(INDEX(Master!$AO:$AO,MATCH(1,(F2=@$AK:$AK)*(AF2=@$AL:$AL),0)),"Not Found")).
Can some one please advise how we can correct this.
regards
aleem
i have VBA code which is working fine, however, for this line of code, the resulting formula is coming with the "@" symbol thus causing invalid results.
VBA Code:
dataSheet.Cells(i, "AG").Formula = "=IF(F" & i & "=AF" & i & ",1,IFERROR(INDEX(Master!$AO:$AO,MATCH(1,(F" & i & "=$AK:$AK)*(AF" & i & "=$AL:$AL),0)),""Not Found""))"
The resulting formula is =IF(F2=AF2,1,IFERROR(INDEX(Master!$AO:$AO,MATCH(1,(F2=@$AK:$AK)*(AF2=@$AL:$AL),0)),"Not Found")).
Can some one please advise how we can correct this.
regards
aleem