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?
Bookmarks