Vlookup blanks = zeros


G

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
 
Ad

Advertisements

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
 
G

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

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
 
G

Guest

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top