Check to see if the vlookup shows up as an error... so it would look like this

=If(Iserror(Vlookup()),"",Vlookup())

"HJ" wrote:

is there a way for a vlookup formula to return a blank cell if it is unable
to find a match in the list?