Is there a way when you do functions that if the function doesn't work, it
doesn't bring back ak value...like you know if ou put FALSE, you will get
#N/A in your cell where the function was..I want it to bring back
nothing.....

=IF(AR39<"BY
OTHERS",VLOOKUP($BY$31,$BZ$18:$CC$20,IF(OR($AR$19= "INTERIOR",$AR$19="20
MIN.(UL 10-B) NEG.PRESSURE", $AR$19="20 MIN.
POS.PRESSURE"),2,IF($AR$19="EXTERIOR",3,IF($AR$19= "45 MIN.(UL 10-B)
NEG.PRESSURE",4,4))), FALSE),"")

in the section where it's false, if you put "" it will bring back #VALUE!


thanks

Wendy