Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking 2 columns of data
I am trying to create a form in which 2 columns of information are linked. In
one column is a product number and the other is a product description. I want the form to have drop downs if possible. I want the result to be if you select the item number the description column fills in or vice versa. I would also like this information to come from a database containing all the product item numbers and descriptions. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking 2 columns of data
Debra Dalgleish has some web pages on this subject.
For the drop down: http://www.contextures.com/xlDataVal01.html And for the subsequent matching fields: http://www.contextures.com/xlFunctions02.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "zemie25" wrote in message ... I am trying to create a form in which 2 columns of information are linked. In one column is a product number and the other is a product description. I want the form to have drop downs if possible. I want the result to be if you select the item number the description column fills in or vice versa. I would also like this information to come from a database containing all the product item numbers and descriptions. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking 2 columns of data
Here's a sample to illustrate one possibility:
http://www.freefilehosting.net/download/3chd6 A simple enquiry sys.xls Data is assumed in sheet: x, cols A and B, from row2 down (Col A = Items, Col B = Descriptions) In x, Create a dynamic defined range, via InsertNameDefine Name: Item Refers to: =OFFSET(x!$A$2,,,COUNTA(x!$A:$A)-1) In another sheet: Enquiry, DVs are created in B3:B10 via Data Validation, Allow: List, Source: =Item In C3, copied down: =IF(B3="","",VLOOKUP(B3,x!A:B,2,0)) returns the descriptions for the items selected in col B (You could hide away sheet: x normally) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "zemie25" wrote: I am trying to create a form in which 2 columns of information are linked. In one column is a product number and the other is a product description. I want the form to have drop downs if possible. I want the result to be if you select the item number the description column fills in or vice versa. I would also like this information to come from a database containing all the product item numbers and descriptions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking data from Rows to columns in seperate worksheets | Excel Worksheet Functions | |||
linking columns | Links and Linking in Excel | |||
Linking data between columns in an automatic way with dynamic link | Excel Discussion (Misc queries) | |||
linking columns | Excel Worksheet Functions | |||
Linking text columns with text and data columns | Excel Worksheet Functions |