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