Replace value based on conditions from multiple columns

I'm running into an issue trying to replace a value within a column that looks at a value within the column itself as well as a value within a separate column.    I have column named [Sender's Posi...