Auto value filled in after dropdown menu value choice

A

AA Arens

I do have two worksheets.

On the second I choose somewhere a value from a range coming from the
1st worksheet (via the combo box).

How to have it performed that after I choose the value, a string will
be filled in in the neighboring column from the 1st WS.

Like:

1st WS
10
20
30 X
40

2nd WS
If I choose "30" from dropdown menu, "Name" will be placed in location
X

Bart
Excel 2003
 
Top