Donkey,

Thanks for the final reply.

With your not inconsiderable help I've solved it. The code you supplied needed a slight adjustment to match the columns on the lookup sheet, but other than that its was great.

Thanks also to Martin who solved the problem, but in a different manner.

Gavin.