vlookup formula

[Gemz]

thanks for advise and info, so you think it might be worth me making a
request to get something done like this within VBA..coz i dont really want to
do numerous formulae.

I appreciate that easier tasks will get a quicker response but i'll still try.

thanks again for all your help.