have a formula return exact text

[katiapro93]

Hello everyone, I believe this is a simple fix which is not comming to me so I am asking for anyone's help. I need to have a vlookup formula in a cell but when it returns the information, I want it to show the actual text and not the formula.

I.e. = on Cell A1 I would write a formula like: =vlookup(d13,Key d1:e5,false) and what I want is for when it returns the information, for anyone who clicks on A1 to see the text and not the formula.

Can this be done?

 

[rob.barnes01]

Could you simply lock the cells which contain the formula and then protect the sheet (unchecking the "Select Locked Cells" checkbox, of course)?

 

[katiapro93]

No, because what I want is to create a form which puts in a phrase. the phrase has some empty blanks which I need for the reader to fill. So if I get the cell to put in the text, the reader just clicks in that box and fills in the blanks, as they are different for each situation.