I am using this formula as a Vlookup in VBA - I need to add an if statement to it so that if the value returned is 0 or #NA then leave the cell blank or "" whatever the vba equivelant is

This is my current formula
"=VLOOKUP(A1, Sheet2!A:B, 2, 0)