Thank you very much for your reply. I think my original message wasn't clear: I need to add the data from one word on Sheet2 to each occurrence of the word in Sheet 1. Will a modified form the formula be able to do this?

Thanks again for your help.