Try
=IF(ISERROR(your_formula),"",your_formula) to hide the #REF errors

Unclick ToolsOptionsViewZero values to hide the 0 answers

--
Regards
Roger Govier
"Em" wrote in message
...
I have used a vlookup formula with success, but I would like to hide all
#REF
and 0 answers that have come up. An IF function won't work, what can I
use
to filter these answers out?