vlookup displaying "0"

[MN_Excel]

Good afternoon,

I am using a v-lookup to bring together information and am having an issue with blank cells. If blank, my preference is to simply have the v-lookup dispaly a blank cell. Instead it is returning a "0." Any ideas on how to change?

Thanks,
MN_Excel

 

[VoG]

Try

=IF(your formula=0,"",your formula)