Vlookup blanks = zeros

M

Marilyn

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

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

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
 
M

Marilyn

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

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
 
M

Marilyn

thanks good to know

T. Valko said:
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
Click to expand...
 
Top