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

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

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

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

List Dependencies
 

That's great!

Thanks for your help.