plz help when i use this

=VLOOKUP(value($B7),Auto!$A$2:$G,3,FALSE)

when the value is not found / not there it returns the error #N/A in the cell and says Error did not find value in vlooup evaluation

this is because the value is not there, what i want to know is if it comes back as #N/A in the cell how can i get it to leave the cell Blank not saying #N/A

thanks