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