You're welcome (from us) !
Glad to hear that you got it working
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"anthonyn" wrote

I think a formatting problem is being caused by me copying
and pasting the lookup data from Acrobat then having excel
generated data in the table array.
I stripped the dashes out of the table array data and then
applied Max's fix to clean up the data from Acrobat and
this seems to have fixed the problem.

Thank you both for you responses, they were of great assistance
Tony