Hello experts
The above line is the formula which works while entering manually in a cell row2. I tried to convert the formula into code and get the result but I am getting an erro. Can someone please help me to correct the code (Starts with .OFFSET In the above). I am getting a Run time error 1004.'=IF(OR(P2={"B2C",""}),"B2C",IFNA(IF(VLOOKUP(P2,'GSTIN Verified'!$D$2:$H$10000,5,0)="ACT","B2B","B2C"),""))
.Offset(1, 19).Formula = "=IF(OR(P2={""B2C"",""}),""B2C"",IFNA(IF(VLOOKUP(P2,'GSTIN Verified'!$D:$H,5,0)=""ACT"",""B2B"",""B2C""),""))"
Thank you in advance.
Bookmarks