Question: excel have vlookup return blank instead of 0?
Answer: If the source value is zero, then VLOOKUP returns 0. ... In this case if the length of what VLOOKUP returns is 0, then Excel doesn't actually do a lookup—it forces a blank to be returned. Only if the length is not 0 is the actual VLOOKUP performed.