Thread: VLOOKUP returns a 0 and I want a blank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KimB KimB is offline
external usenet poster
  
Posts: 4
Default 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)
Reply With QuoteReply With Quote