Hi there,

I have an Excel spreadsheet in which I'm trying to add a column that will populate one of four values based on data elsewhere in the sheet. Here's a list of the values I would need to populate and data elsewhere in the sheet that would need to be present in order for each value to appear:

(1) Official Launch: Cell A1 is blank and the string of text in Cell B1 contains the phrase "sec.gov"

(2) Launch: Cell A1 is blank and the string of text in Cell B1 does not contain the phrase "sec.gov"

(3) Official Close: Cell A1 has a value, and the text in Cell B1 contains the phrase "sec.gov"

(4) Close: Cell A1 has a value, and the text in Cell B1 does not contain the phrase "sec.gov"


I can attach an example sheet with some of the values in columns A and B in my sheet if this would be helpful.

Any idea on how to do this or if it's even possible?