How to pass dynamic excel formulas in a particular cell

Hi Team,

How to pass dynamic excel formulas in a particular cell , i need to pass the dynamic excel formals like

Z:=IFERROR(HLOOKUP($Z$1,A:Y,ROW(),FALSE)*1,IFERROR(HLOOKUP($AD$1,A:Y,ROW(),FALSE)*1,IFERROR(592&HLOOKUP($AF$1,A:Y,ROW(),FALSE)*1,IFERROR(HLOOKUP($AE$1,A:Y,ROW(),FALSE)*1,IFERROR(SUBSTITUTE(592&HLOOKUP($AG$1,A:Y,ROW(),FALSE),“PUB”,"")*1,"")))))
AA: =IFERROR(HLOOKUP($AA$1,A:Y,ROW(),FALSE),"")
AB: =IFERROR(HLOOKUP($AB$1,A:Y,ROW(),FALSE),"")
AC: =INDEX(AB:AB,MATCH(Z2,Z:Z,0))=AB2
How to pass dynamic formulas in Z,AA,AB,AC columns
please help me to slove this issue

Thanks,
Sneha

Hi

Did we try with write cell activity

@nagasneha

Thank You @Palaniyappan , just now i tried but this activity did not work and tell me the another way

Thanks.

What was the issue we were facing on using this

Cheers @nagasneha