hi,

my next question is :

I want to vlookup a value in a range say :

j1:d500

i.e. 0020091 is the lookup value

but on the worksheet the lookup value is in j3 and the
return value is in d20 how do I get this array to work I
have tried alsorts but cannot succeed.

anyone help here please

thanks

steve