How to write formula to particular cell in excel

[nagasneha]

Hii Team,
i wrote formula into particular cell in a excel using write cell activity. when i run the bot i got one error please see the below attachment of error.

i don’t know the error please help me to slove this issue.

Thanks.

[Yoichi]

Hi,

Can you try the following?

"=IFERROR(HLOOKUP($AA$1,A:Y,ROW(),FALSE),"""")"

Regards,

[Manuel_Dominguez (Mdominguez)]

Hello @nagasneha Try to save the Expresion in a Variable and then just add the variable in the Write Range

[ermanoj3101 (MANOJ)]

Hi @nagasneha,

You can use invoke code if it’s not updating from writecell activity.

Pass file path, range and formula.

WriteFormula.xaml (6.0 KB)

Pass your formula to in_Formula variable, i have used concatenate just for testing.