B16 IS BLANK
C16 IS BLANK
D16 IS BLANK
E16 =IF(ISNA(LOOKUP(B16,$N$16:Q$34)),"",LOOKUP(B16,$N$16:$Q$34))
F16 =IF(ISNA(LOOKUP(B16,$N$16:R$34)),"",LOOKUP(B16,$N$16:$R$34))
G17=IF(ISNA(LOOKUP(B16,$N$16:$S$34)),"",LOOKU(B16,$N$16:$S$34))
L16 =C16*E16
DISPLAYS #VALUE!
HOW DO IS DISPLAY BLANK CELL (REQ'D FOR FORM, THAT I WOULD LIKE TO LEAVE ALL FORMULAS IN
C16 IS BLANK
D16 IS BLANK
E16 =IF(ISNA(LOOKUP(B16,$N$16:Q$34)),"",LOOKUP(B16,$N$16:$Q$34))
F16 =IF(ISNA(LOOKUP(B16,$N$16:R$34)),"",LOOKUP(B16,$N$16:$R$34))
G17=IF(ISNA(LOOKUP(B16,$N$16:$S$34)),"",LOOKU(B16,$N$16:$S$34))
L16 =C16*E16
DISPLAYS #VALUE!
HOW DO IS DISPLAY BLANK CELL (REQ'D FOR FORM, THAT I WOULD LIKE TO LEAVE ALL FORMULAS IN