How to: free text cell, that can also assume a value depending on other cell?

I kind of guessed that, looking into it a little it seems like a bit of a new (but very exciting!) world to me.

Thank you for the explaination!

That would be so very kind. I try to post a sample workbook.