If you don't want to change the VLOOKUP, change the master data.
Select cells in question.
Bring up Find & Replace (Ctrl+H)
Leave first line blank
In second line, input:
Under options, select match entire cell contents. Then replace all. Your
formula should now return a blank when it finds a "blank" cell.
*Remember to click "yes" if this post helped you!*