How to get Referenced Cells returning blank cell instead of zero?

Hello,

I have similar problem discussed in following thread.

Referenced cells returning zeros: can these be made blank or string data?

But why I still get the value 0 instead of blank cell when I press ctrl+shift+enter?

My formula = IF(U15="Bank", PROPER(E15),"")
and E15 = VLOOKUP(B15,'Customer Data'!$D$6:$K$100,3,FALSE)

Thanks.

Hi davesexcel, thanks for your reply. Pls see my example attached, I have encountered the same problem in Column "I". Appreciate your help. Thanks.

Hi daddylonglegs, thanks for your suggestion, but it doesn't work. Pls see Column "I" in my attachment. Thanks.

Originally Posted by daddylonglegs

The problem is that the cells in column D do actually contain a zero, they aren't blank. Try this version to exclude zeroes

=IF(VLOOKUP(B2,OLd!$A$2:$D$23,4,FALSE)=0,"",PROPER(VLOOKUP(B2,OLd!$A$2:$D$23,4,FALSE)))

Hi daddylonglegs, thanks a lot for your solution. It works perfectly.