You do it this way:
=if(iserror(yourformula),0,yourformula)

In Excel 2007, you can use the IFError function.

Regards,
Fred.

"dadof4girls" wrote in message
...
Is there any way to get #NUM! error to be hidden? The formula works great
but
for every instant returned that does not have a value iit shows this
error.

Formula used:

=INDEX($B$1:$B$30,SMALL(IF($A$1:$A$30=$C$1,ROW($A$ 1:$A$30)),ROW(A1)))
then ctl shift enter

Names in Column A
Companies in Column B
Name to look up C1