I have used a formula like below, means when there is sheetname soon after the ‘=’ sign then additional symbol ‘@’ comes it self while exporting the excel.
e.g:
string strFormula = "IFERROR(IF(MATCH(1,(D1=‘sheet name’!…... I have attached the sample output file ‘A...(in red). See the screenshot attached. sc_shot1.png (90.5 KB) Which...