How do I set a formula to get text from sheet 2 to sheet 1?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
JJacobs said:
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
Click to expand...

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.
 
If I am reading this correctly, you need to reference and return matching
definitions from text words.
Re-Create the text words list in say A1:A5 in sheet 2, then right beside the
text words and in B1:B5, enter in the definitions that you want returned to
sheet 1. Now you have the text words in column A and the definitions right
beside them in column B.
Go back to sheet 1 and in the first cell beside your text words (ex...words
in A1...type this formula into B1)
=VLOOKUP(A1,Sheet2!A1:B5,2,0)
Now select cell B1 and drag the cursor down. This will copy the formula down
as far as you need to go, while keeping the corresponding reference cell.

regards,
Tom
 
Back
Top