vlookup returns 0 can this be hidden

[Stingrad]

Hi I have a Vlookup formula but if there is nothing in the cell it shows 0 can this be changed to a blank cell? I tried to work out an if formula but with no luck. Thanks

 

[Stormseed]

=if(isna(vlookup()),"",vlookup())

OR

=if(iserror(vlookup()),"",vlookup())

you can use any of the above according to your necessity.

 

[Makrini]

You can do this with an "If" formula - but it is annoying. I usually simple use conditional formatting so that if the cell = 0 then the text and background colour are the same - making it invisible..

if you want to do with the vlookup....

=If(VLookup(whatever one you are using)=0,"",Vlookup(Whatever you are using))

 

[Aladin Akyurek]

Hi I have a Vlookup formula but if there is nothing in the cell it shows 0 can this be changed to a blank cell? I tried to work out an if formula but with no luck. Thanks

You could custom format the formula cell as:

[=0]"";General

What is the exact formula you are invoking?

 

[Stingrad]

Thansk all these work but the conditional formating is the easiest in this case

 

[Aladin Akyurek]

Thansk all these work but the conditional formating is the easiest in this case

Custom formatting should be cheaper...

 

[Makrini]

I agree with Aladin and wish I had thought of it