=IF(ISNA(LOOKUP(D8,$N$8:$N$71))=FALSE,VLOOKUP(E8,$A$2:$C$5,3,FALSE),0)
=IF(ISNA(VLOOKUP(D8,'Prod''n DL'!$A$2:$C$638,3,0)>0)=FALSE,E8*$B$1/VLOOKUP(E8,$A$2:$B$5,2,FALSE),0)
I would like to combine these two formulas into one cell, but I do not want them to be added together. Instead, I would...