Plz help me to replace this
formula with a macro
=IF(A1="","",IF(ISNA(VLOOKUP
(A1,Sheet2!
A:B,2,0)),A1,(VLOOKUP
(A1,SHEET2!A:B,2,0))