VLOOKUP populating multiple cells

Greetings

I have a validation dropdown box that populates multiple cells based on the selection using vlookup formulas. For those selections, that return data with the number "0", I would like to know what I need to do to make those cells remain blank rather than return "0" but I want to keep the vlookup formula for those cells.

Thanks

Thanks a bunch!

Another approach is to format your cells wiith customer number format and use #. Work ofcourse only depending on what you're actual output is but # will return numbers or text as normal, and will hide 0's.