"JJacobs" wrote:

I have text definitions on sheet 2, I have the text words on sheet 1, How can
I create a formula to insert the definitions to the corresponding text with
the words on sheet 1? I am new to excel so please help me step by step. thank
you

You can write a formula so that one cell on a particular sheet will display
what is displayed in the other cell on the other sheet. In order to do this,
you select the cell on the sheet where you want the information to appear and
type and equal sign (=). Then you click over to the other work sheet and
select the cell you want to reference. Press Enter. The formula should look
like ='Sheet1'!A1 or something similar, depending on what specific sheet name
or cell location. I hope this helps.