I'm not sure if there is an easier way but I use an 'IF' and 'ISNA'. for
example:
=if(isna(vlookup(a1,b1:c10,2,false))=true,"",vlookup(a1,b1:c10,2,false))
Basically, it says that if the vlookup returns #N/A then the true part of
the IF statement returns "" (blank) alternatively it returns the value of the
vlookup.
I'm not doing very well posting advice on here but I hope this helps anyway!