Empty Cells which has vlookup formula

Empty Cells which has vlookup formula

Formula on Column 'C'=VLOOKUP($B2,Sheet1!$A$2:$C$100,2,0) which gets the
value from sheet1 its okay. Now i want to put a condition If cell D2:D100
is empty then make C2:C100 empty, which contains vlookup forumula. Clean
the forumula from the cell.
Secondly how do we run this in a macro =VLOOKUP($B2,Sheet1!$A$2:$C$100,2,0).