Perhaps its better to use instead:

In Sheet2,

In C7: =INDEX(Master!D:D,MATCH(A7&"",Master!A:A,0))
In F7: =INDEX(Master!BH:BH,MATCH(A7&"",Master!A:A,0))

Then copy down as before
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"lawmere" wrote in message
...
Hi Max,

Thanks fr the solution sorry i couldn't get back to yesterday had to dash
off . It works fine the only problem is that i cant seem to vary the part
nos
in the column to maybe different characters or digits it seems to be fixed
at
just 4 characters how may i change this pls.