drop down list help

T

tech_2006

hi there, I am new here.

I require some help.

I have a drop down list of values (such as names for example)
I also have in another cell right next to the selection of names, the
employee ID, for example.

What I want is that on A cell away from this list, I want the cell to
have a drop down list box. This is easily done (Data validation)
The next thing I want is that when the user selects an item from this
drop down list, I want the employee ID, for the selected value, to be
populated appropriatly in the next cell.

is this possible?

how?

thanks!
 
P

Pete_UK

Assume the user selects the item in cell A1. In cell B1 enter this
formula:

=VLOOKUP(A1,L$1:M$20,2,0)

this will bring the ID from the table of names and ID (assumed to
occupy L1 to M20) - adjust cell references as appropriate.

Hope this helps.

Pete
 
Top