If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I set a formula to get text from sheet 2 to sheet 1?
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 |
#2
|
|||
|
|||
How do I set a formula to get text from sheet 2 to sheet 1?
"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. |
#3
|
|||
|
|||
How do I set a formula to get text from sheet 2 to sheet 1?
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 "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 |
Thread Tools | |
Display Modes | |
|
|