The usual way of avoiding such errors being displayed is
=IF(ISERROR(yourformula),"",yourformula), hence try
=IF(ISERROR(INDEX(INDIRECT("$a$1:$a$500"),MATCH(SM ALL($C$1:$C$500,ROWS($IV$1:IV1)),$C$1:$C$500,0))), "",INDEX(INDIRECT("$a$1:$a$500"),MATCH(SMALL($C$1: $C$500,ROWS($IV$1:IV1)),$C$1:$C$500,0)))
--
David Biddulph

"Gotroots" wrote in message
...

The following formula works fine however it returns #NUM! when there are
no
more records to display. I do not want the error to return.

=INDEX(INDIRECT("$a$1:$a$500"),MATCH(SMALL($C$1:$C $500,ROWS($IV$1:IV1)),$C$1:$C$500,0))