Excel 2007 : How to search text string within a column and return search value in adjacent column

Hi

I'm trying to do something I thought would be quite simple in excel, yet it's causing me problems getting it to work.

I have multiple words (say 5) that i know are contained in a column of data (shop1, shop2, shop3 in my example). what i want to do is say "if cell A1 contains shop1, shop2 or shop3, output whichever one is found in cell B1". only one hit will be in a cell (i.e. shop1 and shop2 won't be in the same cell).

can anyone help? this is driving me nuts

See example below.

Column A
shop1, 23 smith st
234 forfar st, shop 2
shop1 42, bob street

Column B
return the search value if found.