I'm not sure if there is an easier way but I use an 'IF' and 'ISNA'. for
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
I'm not doing very well posting advice on here but I hope this helps anyway!