I had the need this morning in Excel to have the contents of one cell be based on the text of what was in another cell. For example, if the contents of the first cell was 1, the contents of the next cell needed to be 3rd Saturday – DEV. A little Google-FU later and I was able to find out how to do this, which saved me a boat load of time this morning.
In the cell that is empty, use a formula like this:
=IF(ISNUMBER(SEARCH(“3″,B2)),”1st Saturday – PROD”)
What this does is if the number is 3, in cell B2, it will place the text 1st Saturday – PROD into your empty cell. You can also string it together like this for multiple values:
=IF(ISNUMBER(SEARCH(“3″,B2)),”1st Saturday – PROD”,IF(ISNUMBER(SEARCH(“4″,B2)),”2nd Saturday – PROD”,IF(ISNUMBER(SEARCH(“1″,B2)),”3rd Saturday – DEV”,IF(ISNUMBER(SEARCH(“2″,B2)),”4th Saturday – DEV”))))