Hi

I am using 2007 and would like to drop down from a list in a cell and have a
lookup in the same cell

eg. I have a list of employees and their numbers = emp_list and emp_number

emp_list emp_number
Joe 1
Jane 2
Bob 3


I want users to be able to select employees from a list then the model will
look up the employee number IN THE SAME CELL.

Now, I know how to get a drop down list of employees using date validation =
emp_list. And I know how to lookup up the emp_number in a seperate cell using
INDEX(MATCH()) or VLOOKUP.

But I have many columns of these so I would like to be able to have the
drop-down and the number in the same cell.

so, In A1, there would be a drop down which had the emp_list. When the
employee is selected, the value in A1 would be the employee number.

I need to drag and drop over thousands of records so it needs to be in-cell
(no in a seperate drop-down box)

Is this possible?

Thanks
s