drop down list question

[billy_cormic]

hello,
I am rather new to excel programing and have a simple question. I
am hoping that someone can set me in the right direction. I have a
drop down list and the ListFillRange is set to Sheet2!$A$2:$A$5. Is
there an easy way to store a different value for each item in the
listfillrange? For example, if an item in the drop down is displayed
as Bob Smith, is there a way to store an employee number with Bob Smith
in the drop down? I hope that this is clear enough. I want to do this
so that I can use the employee number in another cell.

Thanks,
Billy

 

[Jason Morin]

What you can do is create a table of employees and their
corresponding employees numbers, and then use VLOOKUP to
return the employees number. For example, let's assume in
col. A, sheet1, you have names and in col. B, their
employees numbers.

Now let's assume your LinkedCell for your drop-down is D1
on another sheet. Use:

=VLOOKUP(D1,Sheet1!A:B,2,0)

to pull in the employee #. For some examples on VLOOKUP,
see:

http://www.contextures.com/xlFunctions02.html
http://www.techonthenet.com/excel/formulas/vlookup.htm\

HTH
Jason
Atlanta, GA