Thanks for replying hectop but it would be a bit awkward to post the sheet at the moment because it contains competitors names and to delete or change them would corrupt the lookup files.