Its easy enough to setup the first function, for instance if cell A1=G .. But what text do you want to show in cell B1 ?

If we can discuss specific text you would like to show or not show, I can help write the formula exactly so all you have to do is copy and paste the formula into the correct cell/s.

Could I have the same cell display different text depending on what I put in cell A1. For example, A1=G, then B1=Hello. A1=B, then B1=Goodbye. Etc. If you use these to write formulas, then I can write it.