You're welcome.

Slight amendment to the range in:
=INDEX($D$1:$D$7,MATCH(TRUE,$C$1:$C$7=A1,0))

Above should have read as,
array-entered in B1, then copied down:
=INDEX($D$1:$D$8,MATCH(TRUE,$C$1:$C$8=A1,0))

(I missed row 8 of your range as posted earlier)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Doug" wrote:
Thanks Max