=if(iserror(vlookup),"",vlookup)

or

=if(countif(A:A,value),vlookup(value,A:F,2,0),"")



hopefully you can apply that approach to your function.

--
Regards,
Tom Ogilvy

"Wendy" wrote in message
...
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