Excel / GSpreadsheets：基于列表中包含的单词查找返回值

This is my data:

这是我的数据:

Sheet1:

   A                      B
PUMPKIN CAFE          (formula)
TESCO STORES 5555     (formula)
THE WINDSOR CASTLE    (formula)
TESCO STORES 2344     (formula)
THE WINDSOR CASTLE    (formula)
   A