How to change a formula to VBA

[keranali]

Hi all I have a formula which works with a validation data box to automatically populate col G,H,I,K and M with data from another sheet how possible is to get this formula into a vba format.

=IFERROR(IF(VLOOKUP(A2,DATALIST,2,FALSE)="","",VLOOKUP(A2,DATALIST,2,FALSE)),"")

Thanks
K

 

[Domenic]

Maybe...

Range("G2").Formula = "=IFERROR(IF(VLOOKUP(A2,DATALIST,2,FALSE)="""","""",VLOOKUP(A2,DATALIST,2,FALSE)),"""")"

or

Range("G2").FormulaR1C1 = "=IFERROR(IF(VLOOKUP(RC1,DATALIST,2,FALSE)="""","""",VLOOKUP(RC1,DATALIST,2,FALSE)),"""")"

 

[keranali]

Thank you very much Domenic, it worked well

K