Incase you are using XL2007 checkout help on the function IFERROR()

--
Jacob


"Jacob Skaria" wrote:

Depends on what you have in ColA and colC

If ColC is having numerics...try
=IF(COUNT($C$1:$C$500)<ROWS($IV$1:IV1),"",(INDEX(I NDIRECT("$a$1:$a$500"),MATCH(SMALL($C$1:$C$500,ROW S($IV$1:IV1)),$C$1:$C$500,0))))

'try if colC will have both text and numerics
=IF(COUNTA($C$1:$C$500)<ROWS($IV$1:IV1),"",(INDEX( INDIRECT("$a$1:$a$500"),MATCH(SMALL($C$1:$C$500,RO WS($IV$1:IV1)),$C$1:$C$500,0))))


--
Jacob


"Gotroots" wrote:


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))