search text of cell in a range and return the contents in the corresponding column

Hi all
I am trying to look for a specific word within the text in a range of cells and result should be the value in the corresponding column.
example.
Look for CIBC and result should be "4km"
Bank TD 2km
RBC Bank 3km
CIBC Bank 4km
Scotial Bank 5km
National Bank 6km
Bank of America 7km
HBL Bank 8km
HSBC Bank 9km

Many Thanks