Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Dependencies
Hi,
I'm hoping someone can help me. I have two dropdown lists and for each element on one list I have a corresponding element on the other list. When the user selects an item from list one - I want to automatically populate the second cell with the corresponding element. Example: A 10 B 20 C 30 D 40 E 50 So when user picks 'B' from the first drop down list. The adjacent cell changes to '20' Do I need some VBA or is there a simpler solution? Thanks in advance, Vinnie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Dependencies
=Vlookup() is a favorite means; & Fully explained in Help.
wrote in message oups.com... Hi, I'm hoping someone can help me. I have two dropdown lists and for each element on one list I have a corresponding element on the other list. When the user selects an item from list one - I want to automatically populate the second cell with the corresponding element. Example: A 10 B 20 C 30 D 40 E 50 So when user picks 'B' from the first drop down list. The adjacent cell changes to '20' Do I need some VBA or is there a simpler solution? Thanks in advance, Vinnie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Dependencies
Use INDIRECT.
If your first list is in A1 and your second list in B1 then in B1 Data/Validation , "list" from the "Allow" menu and in the formula box type: = INDIRECT(A1) HTH Jean-Guy "Jim May" wrote: =Vlookup() is a favorite means; & Fully explained in Help. wrote in message oups.com... Hi, I'm hoping someone can help me. I have two dropdown lists and for each element on one list I have a corresponding element on the other list. When the user selects an item from list one - I want to automatically populate the second cell with the corresponding element. Example: A 10 B 20 C 30 D 40 E 50 So when user picks 'B' from the first drop down list. The adjacent cell changes to '20' Do I need some VBA or is there a simpler solution? Thanks in advance, Vinnie |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Dependencies
Please disregard my post, I misread yours.....my appologies!
Regards Jean-Guy " wrote: Hi, I'm hoping someone can help me. I have two dropdown lists and for each element on one list I have a corresponding element on the other list. When the user selects an item from list one - I want to automatically populate the second cell with the corresponding element. Example: A 10 B 20 C 30 D 40 E 50 So when user picks 'B' from the first drop down list. The adjacent cell changes to '20' Do I need some VBA or is there a simpler solution? Thanks in advance, Vinnie |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Dependencies
That's great!
Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List box setup, placement, and functionality | New Users to Excel | |||
Data Validation and Blanks in List | Excel Worksheet Functions | |||
Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) |