Thread: VLOOKUP returns a 0 and I want a blank
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
  
Posts: 698
Default 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)


Reply With QuoteReply With Quote