software

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:
A10
B20
C30
D40
E50So 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=Vlookup() is a favorite means; amp; Fully explained in Help.

gt; wrote in message oups.com...
gt; Hi,
gt;
gt; I'm hoping someone can help me.
gt; I have two dropdown lists and for each element on one list I have a
gt; corresponding element on the other list. When the user selects an item
gt; from list one - I want to automatically populate the second cell with
gt; the corresponding element.
gt;
gt; Example:
gt; A 10
gt; B 20
gt; C 30
gt; D 40
gt; E 50
gt;
gt;
gt; So when user picks 'B' from the first drop down list. The adjacent cell
gt; changes to '20'
gt; Do I need some VBA or is there a simpler solution?
gt;
gt; Thanks in advance,
gt; Vinnie
gt;
Use INDIRECT.

If your first list is in A1 and your second list in B1 then in B1
Data/Validation , quot;listquot; from the quot;Allowquot; menu and in the formula box type: =
INDIRECT(A1)HTH
Jean-Guy

quot;Jim Mayquot; wrote:

gt; =Vlookup() is a favorite means; amp; Fully explained in Help.
gt;
gt; gt; wrote in message
gt; oups.com...
gt; gt; Hi,
gt; gt;
gt; gt; I'm hoping someone can help me.
gt; gt; I have two dropdown lists and for each element on one list I have a
gt; gt; corresponding element on the other list. When the user selects an item
gt; gt; from list one - I want to automatically populate the second cell with
gt; gt; the corresponding element.
gt; gt;
gt; gt; Example:
gt; gt; A 10
gt; gt; B 20
gt; gt; C 30
gt; gt; D 40
gt; gt; E 50
gt; gt;
gt; gt;
gt; gt; So when user picks 'B' from the first drop down list. The adjacent cell
gt; gt; changes to '20'
gt; gt; Do I need some VBA or is there a simpler solution?
gt; gt;
gt; gt; Thanks in advance,
gt; gt; Vinnie
gt; gt;
gt;
gt;
gt;

Please disregard my post, I misread yours.....my appologies!

Regards
Jean-Guy

quot; wrote:

gt; Hi,
gt;
gt; I'm hoping someone can help me.
gt; I have two dropdown lists and for each element on one list I have a
gt; corresponding element on the other list. When the user selects an item
gt; from list one - I want to automatically populate the second cell with
gt; the corresponding element.
gt;
gt; Example:
gt; A10
gt; B20
gt; C30
gt; D40
gt; E50
gt;
gt;
gt; So when user picks 'B' from the first drop down list. The adjacent cell
gt; changes to '20'
gt; Do I need some VBA or is there a simpler solution?
gt;
gt; Thanks in advance,
gt; Vinnie
gt;
gt;

That's great!

Thanks for your help.