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