Can I do this in Excel?

Hi,  I am trying to create a helpful tool for my coworkers to help with some of our workflows. Our system sends automated messages base on two different data fields.  If the data in one field is thi...