Yeah I would be happy to write something up for you. I am thinking of it going something like this. on 1 worksheet you have all of your values that you want to search through in column A. on another worksheet in the same workbook you have 2 columns of data. One of the string to search and one of the result, for example McDonalds | Food etc. Then when you have all this entered on the 2nd sheet you run the code that I write and that will give you your result in column B on the first worksheet. Sound good? Let me know and I will write it up.

Thanks