V Look Up...how to bring over blanks?

[Statz]

Many times when I'm using V Look up. If there is no data in the data base that I'm using to grab data from it shows a ZERO "0". Anyway to make it show blank? I attached sample. Thanks

[AlKey]

Try this

Please Login or Register  to view this content.

[Statz]

Try this

Please Login or Register  to view this content.

This formula works for the example I provided. But the reason I provided the example is because the actual data I'm having the issue with I can't put online. So when I worked that formula into my real data it actually made all the cells go blank (but no error) so it does seem like it's working correctly just not with what I want.

The only main difference is I'm looking up letters & in the example I posted I used #'s. Does that matter? Thanks

[AlKey]

It is your responsibility to provide accurate data.
Use this one

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

[Statz]

It is your responsibility to provide accurate data.
Use this one

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

I understand about being my responsibility on providing accurate data. I've done the same practice many times before and I always am able to figure out how to make it worked. This formula just more complex. I apologize for the time wasted. I did get it to work thanks to your 2nd formula. I greatly appreciate the time you spent and quick response as well. Thanks!