Good afternoon vandanavai
The problem here lies in the fact that you are including a set of quotes in the formula - Excel thinks that the first set signifies the end of a string and the second set signifies the start of another, and consequently the formula gets confused when you attempt to post it.
Range("A5.A5000").Formula = "=IF(ISNA(VLOOKUP($A$1&ROW()-4,Register!$A:$L,4,FALSE)),"",(VLOOKUP($A$1&ROW()-4,Register!$A:$L,4,FALSE)))"
So what we need to do is remove them and replace them with the ASCII code for a quote (34) to force them into the formula that way, thus :
HTH
DominicB
Edit : Correct typo
Bookmarks