Vlookup blanks = zeros

[Guest]

Hello
=IF(ISERROR(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE))," ",VLOOKUP(C4,'Jan 3
06'!C3:F28,4,FALSE)) Whenever there is a blank in the cell is returns 0.
If the cell is blank I want the answer to be blank not a zero. Can someone
help me thanks

 

[T. Valko]

Try this:

=IF(COUNTIF('Jan 3 06'!C3:C28,C4),IF(VLOOKUP(C4,'Jan 3
06'!C3:F28,4,0)=0,"",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)),"")

Biff

 

[T. Valko]

Just in case the values you're returning are numbers use this one:

=IF(COUNTIF('Jan 3 06'!C3:C28,C4),IF(VLOOKUP(C4,'Jan 3
06'!C3:F28,4,0)="","",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)),"")

Biff

 

[Guest]

thanks T Valko this works.. I noticed that your formula s has a 0 instead
of the word false. what is the difference what does 0 mean in this
position thanks

 

[T. Valko]

The 0 means the same thing as FALSE, look for an exact match. I'm just lazy
and don't like to type a lot! 1 would mean the same thing as TRUE, look for
an approximate match.

Biff

 

[Guest]

thanks good to know

The 0 means the same thing as FALSE, look for an exact match. I'm just lazy
and don't like to type a lot! 1 would mean the same thing as TRUE, look for
an approximate match.

Biff

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

thanks good to know