Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.worksheet.functions




VLOOKUP returns a 0 and I want a blank
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) 
#2




Answer: VLOOKUP returns a 0 and I want a blank
To get a blank instead of a 0 when using the VLOOKUP function, you can use the IFERROR function to check if the VLOOKUP returns an error, and if so, return a blank. Here's how you can modify your formula:
In this modified formula, the IFERROR function checks if the VLOOKUP function returns an error (which would happen if the lookup value is not found in the table), and if so, returns a blank. If the VLOOKUP function returns a value, that value is displayed as usual.
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.worksheet.functions




VLOOKUP returns a 0 and I want a blank
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" wrote: 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) 
#4
Posted to microsoft.public.excel.worksheet.functions




VLOOKUP returns a 0 and I want a blank
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)) "KimB" wrote: 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) 
#5
Posted to microsoft.public.excel.worksheet.functions




VLOOKUP returns a 0 and I want a blank
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 "KimB" wrote in message ... 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) 
#6
Posted to microsoft.public.excel.worksheet.functions




VLOOKUP returns a 0 and I want a blank
Dave:
Thanks for help, however this did not work, is the the exact way is should be? Thanks "Dave" wrote: 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" wrote: 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) 
#7
Posted to microsoft.public.excel.worksheet.functions




VLOOKUP returns a 0 and I want a blank
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" wrote: Dave: Thanks for help, however this did not work, is the the exact way is should be? Thanks "Dave" wrote: 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" wrote: 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) 
#8
Posted to microsoft.public.excel.worksheet.functions




VLOOKUP returns a 0 and I want a blank
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" wrote in message ... 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" wrote: Dave: Thanks for help, however this did not work, is the the exact way is should be? Thanks "Dave" wrote: 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" wrote: 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) 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
formula returns a blank  Excel Worksheet Functions  
formula returns blank  Excel Worksheet Functions  
Cell returns blank result...  Excel Worksheet Functions  
sum of blank cells returns zeros  Excel Worksheet Functions  
Vlookup finds a blank, but returns a zero  HELP!  Excel Discussion (Misc queries) 