VLOOKUP returns a 0 and I want a blank

K

KimB

This is my formula, how do I get a blank instead of a 0?
=VLOOKUP(B4,'[New Number Scheme.xls]Conveyor Schedule'!$A:$AD,11,FALSE)
 
D

Dave

Hi, This is a bit long, but...
=IF( =VLOOKUP(B4,'[New Number Scheme.xls]Conveyor
Schedule'!$A:$AD,11,0)=0,"",VLOOKUP(B4,'[New Number Scheme.xls]Conveyor
Schedule'!$A:$AD,11,0)
Regards - Dave.
 
S

Sean Timmons

easiest way is:

=IF(VLOOKUP(B4,'[New Number Scheme.xls]Conveyor
Schedule'!$A:$AD,11,FALSE)=0,"",VLOOKUP(B4,'[New Number Scheme.xls]Conveyor
Schedule'!$A:$AD,11,FALSE))
 
L

L. Howard Kittle

Use an IF statement like such, change ranges to suit your sheet.

=IF(VLOOKUP(A1,G1:H3,2,0)=0,"",VLOOKUP(A1,G1:H3,2,0))

HTH
Regards,
Howard
 
K

KimB

Dave:
Thanks for help, however this did not work, is the the exact way is should be?
Thanks

Dave said:
Hi, This is a bit long, but...
=IF( =VLOOKUP(B4,'[New Number Scheme.xls]Conveyor
Schedule'!$A:$AD,11,0)=0,"",VLOOKUP(B4,'[New Number Scheme.xls]Conveyor
Schedule'!$A:$AD,11,0)
Regards - Dave.


KimB said:
This is my formula, how do I get a blank instead of a 0?
=VLOOKUP(B4,'[New Number Scheme.xls]Conveyor Schedule'!$A:$AD,11,FALSE)
Click to expand...
Click to expand...
 
D

Dave

Hi,
This page wraps long formulas, inserting annoying characters in the process.
You will probably find an extra space at each wrap point which you'll have
to remove.
ie after the first instance of Conveyor - remove one space
after the second instance of Number - remove one space
after the second instance of Conveyor - remove one space
Regards - Dave.

KimB said:
Dave:
Thanks for help, however this did not work, is the the exact way is should be?
Thanks

Dave said:
Hi, This is a bit long, but...
=IF( =VLOOKUP(B4,'[New Number Scheme.xls]Conveyor
Schedule'!$A:$AD,11,0)=0,"",VLOOKUP(B4,'[New Number Scheme.xls]Conveyor
Schedule'!$A:$AD,11,0)
Regards - Dave.


KimB said:
This is my formula, how do I get a blank instead of a 0?
=VLOOKUP(B4,'[New Number Scheme.xls]Conveyor Schedule'!$A:$AD,11,FALSE)
Click to expand...
Click to expand...
Click to expand...
 
L

L. Howard Kittle

I think you just need to remove the second "equal" sign and there is a space
just before the second "equal" sign.

=IF(VLOOKUP(B4,'[New Number Scheme.xls]Conveyor
Schedule'!$A:$AD,11,0)=0,"",VLOOKUP(B4,'[New Number Scheme.xls]Conveyor
Schedule'!$A:$AD,11,0)

Regards,
Howard

Dave said:
Hi,
This page wraps long formulas, inserting annoying characters in the
process.
You will probably find an extra space at each wrap point which you'll have
to remove.
ie after the first instance of Conveyor - remove one space
after the second instance of Number - remove one space
after the second instance of Conveyor - remove one space
Regards - Dave.

KimB said:
Dave:
Thanks for help, however this did not work, is the the exact way is
should be?
Thanks

Dave said:
Hi, This is a bit long, but...
=IF( =VLOOKUP(B4,'[New Number Scheme.xls]Conveyor
Schedule'!$A:$AD,11,0)=0,"",VLOOKUP(B4,'[New Number Scheme.xls]Conveyor
Schedule'!$A:$AD,11,0)
Regards - Dave.


:

This is my formula, how do I get a blank instead of a 0?
=VLOOKUP(B4,'[New Number Scheme.xls]Conveyor
Schedule'!$A:$AD,11,FALSE)
Click to expand...
Click to expand...
Click to expand...
 
Top