Excel formula if cell contains partial text from another

Excel formula if cell contains partial text from another pictures 5

Home > Excel formula if cell contains partial text from

Excel formula if cell contains partial text from another