Excel check if cell contains text from column

Excel check if cell contains text from column pictures 5
Home > Excel check if cell contains text from

Excel check if cell contains text from column