In XL03
=IF(ISERROR(your formula),"",your formula)

=IF(ISERROR(INDEX($B$1:$B$30,SMALL(IF($A$1:$A$30=$ C$1,
ROW($A$1:$A$30)),ROW(A1)))),"",
INDEX($B$1:$B$30,SMALL(IF($A$1:$A$30=$C$1,ROW($A$1 :$A$30)),ROW(A1))))


In XL07
=IFERROR(INDEX($B$1:$B$30,SMALL(IF($A$1:$A$30=$C$1 ,
ROW($A$1:$A$30)),ROW(A1))),"")


If this post helps click Yes
---------------
Jacob Skaria


"dadof4girls" wrote:

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