Okay. I have a datafeed in excel. I need a code to do the following + I have a list of variables to be looked for + Needs to search a cell for a set of specific variables + If it finds a variable it will then add a second variable into a seperate cell. + Each variable has a different second variable. Okay ill give an example, Search cell A3 for the word 'football' if it finds the word then insert 'sports' into cell B3 .. if not then search for the word 'clothing' if it finds the word then insert 'fashion' into cell B3. Once it finds the variable then move onto A4 and start again. Any questions feel free to ask, probably prefer this in PHP or VB as they are what i have rough knowledge in. Thanks