Excel formula to find a string in column cells and output a value in column cells to the right.

Hi There,

I am trying to create a formula to find a string(s) in a column of data. The column in approx 3000 rows with different words in each cell. Some contain the strings, some do not.  If a string is found, I need  to output a value in the cell in the column to the right of it. It is not case sensitive eg. search "Dog" or "dog".

 

Logic example:

 

If the word "dog" is found in the cell, then output the word "dog" in the cell in the next column.

 

else if, the word "groom" is found in the cell, then output the word "grooming" in the cell in the next column.

 

else if, the word "vet" is found in the cell, then output the word "vet" in the cell in the next column.

 

else if, the word "food" is found in the cell, then output the word "pet food" in the cell in the next column.

 

else if, the word "fish" or "aqua" is found in the cell, then output the words "fish and aquatics" in the cell in the next column.

 

else, return "pet shops" to all those remaining cells in the next column. 

 

Note:
Some of the words that I am looking for in the column, are (example) "easydoglife" and I would need the formula to recognise "dog" and output it to the cell in the column to the right.

I am using an old version of excel, for windows XP I think? but I don't think this matters

Could anyone help turn my pseudo-mess into a nice formula ?

 

Thanks in advance, I'm losing hair...

Chris.