drop down list help

  • Thread starter Thread starter tech_2006
  • Start date Start date
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!
 
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
 
Back
Top