Vlookup blanks = zeros
 

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

Vlookup blanks = zeros
 

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

"Marilyn" wrote in message
...
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

Vlookup blanks = zeros
 

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

"T. Valko" wrote in message
...
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

"Marilyn" wrote in message
...
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

Vlookup blanks = zeros
 

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" wrote:

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

"T. Valko" wrote in message
...
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

"Marilyn" wrote in message
...
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

Vlookup blanks = zeros
 

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

"Marilyn" wrote in message
...
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" wrote:

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

"T. Valko" wrote in message
...
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

"Marilyn" wrote in message
...
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

Vlookup blanks = zeros
 

thanks good to know

"T. Valko" wrote:

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

"Marilyn" wrote in message
...
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" wrote:

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

"T. Valko" wrote in message
...
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

"Marilyn" wrote in message
...
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

Vlookup blanks = zeros
 

You're welcome. Thanks for the feedback!

Biff

"Marilyn" wrote in message
...
thanks good to know

"T. Valko" wrote:

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

"Marilyn" wrote in message
...
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" wrote:

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

"T. Valko" wrote in message
...
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

"Marilyn" wrote in message
...
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