Home » questions » Having trouble linking Excel worksheets together in a formula?

Having trouble linking Excel worksheets together in a formula?

7
2006-08-04 04:41:33, Category: Programming & Design
I have two seperate worksheets and in the first one, I have a lot of codes describing different jobs the lads in our factory do. On the second worksheet, I would like to make it so that if I entered one of the codes on the first worksheet onto the second worksheet, the job desription would appear on the second worksheet. For example: if A = cleaning on the first worksheet, then if I enter A in the column for codes on the second worksheet, I would like the word "cleaning" to appear in a different column next to the code column. I'm sorry if this confusing for anyone, but it's cracking me up as I know it's possible and I can't do it. Help!!!!!! Any more info needed, I will gladly provide.

Answers

  1. Lewiy

    On 2006-08-04 10:14:09


    On the second worksheet you need to use the formula VLOOKUP In the cell you want the result to be displayed type "=VLOOKUP" then click the cell where you want to be able to put the code to search for, then a comma, then go back to the first worksheet and select the whole of the 2 columns where the details are kept (i.e. put the codes in column A and the descriptions in column B and select columns A and B), then another comma, then type "2", then another comma, then finally type "FALSE)". Now when you enter a code in the second worksheet, Excel will search column A in the first worksheet for that code and return the result that is in column B. Hope that makes sense!

  2. Vearn

    On 2006-08-04 04:54:59


    Ok, i think i understand your situation. Wheen you are refering to new worksheet i assume that it is the same file but different sheet. Ok? In order for you to do the relations, you will need to put formula to link the code from sheet 1 to sheet 2. The coding can be anable by using a table for reference. That means you can put certain command, (if you know scrip editor, it would help). To search for certain coding to appear in the second sheet. For more info look at the source below. I would suggest you to put these data into Microsoft Access. That will provide a better tool for database handling. Let me know if you need any more help. Cheers, Vearn

  3. ~~> SDK <~~

    On 2006-08-04 05:10:51


    Well that may not be not possible. It is too confusing

  4. batzoid

    On 2006-08-04 15:12:23


    You create a list on the first sheet with 2 columns, codes and descriptions. On the second sheet you type the code in a cell. In the cell on the right (say) use a "vlookup" function to look up the description from the previous sheet and display it next to the code you typed in.

  5. AnalProgrammer

    On 2006-08-04 05:17:34


    In Sheet 1 I typed the following in different cells A Cleaning B Mechanic In Sheet 2 I typed A in cell 1 Then in cell 2 I typed =LOOKUP(A1,Sheet1!A1:B2) It worked for me.

  6. alfasan2000

    On 2006-08-04 05:31:31


    On the second worksheet select the cell you want the result to show in. In the formula box type (without quotes) "=" Click on tab (at bottom of sheet) to select the first worksheet. Select cell with formula in Click enter. Hey Presto

  7. banksify

    On 2006-08-04 04:51:56


    The same way you would if only using one worksheet except when you need to identify the cell reference you click on the second worksheet and selct the appropriate cell. The formula will automatically link the two sheets. Have just tried this on Excel myself and have solution. If you have e-mail then i can send you the sheet