Excel if contains partial text then return value

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

Excel if contains partial text then return value