How to paste Hlookup formulas in to particular column in a excel. for AA column formuls like AA: =IFERROR(HLOOKUP($AA$1,A:Y,ROW(),FALSE),"")

[nagasneha]

Hi Team,

i want to apply this formulas in particular column like Z,AA,AB,AC entire columns dynamically

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 apply this formulas into Z,AA,AB,AC entire columns in a excel ,please help me to slove this issue.

Thanks.

[Palaniyappan (Forum Leader)]

Hi
Did this thread help on this scenario

How to drag a formula in the entire column in excel

Thanks a million Clayton. This will definitely help me to do many Excel automation activities easily

@nagasneha

[nagasneha]

Thanks @Palaniyappan, i tired write cell activity but it showing error like this below attachment. Is this correct way to write the formula into write cell activity?

Actulllay i need to paste this formula (=INDEX(AB:AB,MATCH(Z2,Z:Z,0))=AB2
) in a AC column . How to paste this formula into AC column please help me to slove this issue ASAP.

Thanks.