=IF(ISERR(INDEX($E$2:$E$62933,SMALL(IF($B$2:$B$629 33=B62938,ROW($E$2:$E$6293
3)),$F$2))),0,INDEX($E$2:$E$62933,SMALL(IF($B$2:$B $62933=B62938,ROW($E$2:$E$
62933)),$F$2)))

All on one line, watch out for wordwrap......

Vaya con Dios,
Chuck, CABGx3


"Rodney" wrote in message
...

I have my statement working OK, thanks to all.

=INDEX($E$1:$E$62933,SMALL(IF($B$1:$B$62933=B62938 ,ROW($E$1:$E$62933)),$F$2)
)

When the name is not found in the array,
I have a #NUM error value.
Is there a way to test for error, and replace with a zero
to the above statement please?


As an aside, I had the devils own trouble getting sense from
the above statement, when I used the array E2:E62933
(I had a header row, and felt I not need to include in the array)
when I used E1:E62933 everything worked fine.
Why is that?

Thankyou.
Rodney