I'm sorry that the description is so bad. I will try to elaborate with an example.
1 - Educational platform. I have thousands of sentences like the one below.
2 - I need to be able to substitute the word "achieved" by the word GAP.
3 - I need the word GAP because in our php/mysql set up we then substitute GAP for (............) or many other formats.
4 - I need a LOOKUP ie: the answer, achieved, is lookedup in the question, and GAP is substituted.
You may be wondering why I don't just add the My daughter GAP or (............) from outset. This is because the same sentence is used for many different types of exercises.
I have a sentence arranger, gap fills, multiple choice, matching two halves etc... so I need the complete sentence.

My daughter achieved high marks in her exams, because she makes an effort to study as often as possible. (question column) achieved (answer column)
needs to be converted to
My daughter GAP high marks in her exams, because she makes an effort to study as often as possible.

I need to apply the same formula to 100-1000 sentences. So would I need a macro or just create the formula for one row then apply to the sheet?
Thanks in advance.