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