Excel if cell contains partial text then return value from another

Excel if cell contains partial text then return value from another pictures 5
Home > Excel if cell contains partial text then return value from

Excel if cell contains partial text then return value from another