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
|
|||
|
|||
Linking Data Columns
I created a table in EXCEL that I'll be entereing from day to day with data
of several organizations. two of the main columns are the "Organisation's name" and another column for the organisation's "ID number"..... what I want to do is to have a formula in my table so that anytime I select an organization's Name, from a drop-down list the adjacent cell should automatically also fill up with its corresponding ID Number.... I have created (in another sheet in the same work book) two columns sided by side showing the ID numbers and corresponding organisation names PLEASE HELP!! PLEASE HELP!! PLEASE HELP!! |
#2
|
|||
|
|||
Linking Data Columns
Hi,
look Debra dependent list, http://www.contextures.com/xlDataVal02.html "DESPERADO" wrote: I created a table in EXCEL that I'll be entereing from day to day with data of several organizations. two of the main columns are the "Organisation's name" and another column for the organisation's "ID number"..... what I want to do is to have a formula in my table so that anytime I select an organization's Name, from a drop-down list the adjacent cell should automatically also fill up with its corresponding ID Number.... I have created (in another sheet in the same work book) two columns sided by side showing the ID numbers and corresponding organisation names PLEASE HELP!! PLEASE HELP!! PLEASE HELP!! |
#3
|
|||
|
|||
Linking Data Columns
=VLOOKUP(cell_value,table,2,false) entered in cell adjacent to your
dropdown. Sheet2 contains the table with names in column A and ID numbers in column B e.g. sheet1 A1 has dropdown In B1 enter =VLOOKUP(A1,Sheet2!$A$1:$B$20,2,FALSE) Gord Dibben MS Excel MVP On Thu, 1 Apr 2010 06:16:01 -0700, DESPERADO wrote: I created a table in EXCEL that I'll be entereing from day to day with data of several organizations. two of the main columns are the "Organisation's name" and another column for the organisation's "ID number"..... what I want to do is to have a formula in my table so that anytime I select an organization's Name, from a drop-down list the adjacent cell should automatically also fill up with its corresponding ID Number.... I have created (in another sheet in the same work book) two columns sided by side showing the ID numbers and corresponding organisation names PLEASE HELP!! PLEASE HELP!! PLEASE HELP!! |
Thread Tools | |
Display Modes | |
|
|