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.
=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))
Dave:
Thanks for help, however this did not work, is the the exact way is should be?
Thanks
Dave said:
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 said:
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)
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 said:
Dave:
Thanks for help, however this did not work, is the the exact way is should be?
Thanks
Dave said:
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 said:
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)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.