Home |
Search |
Today's Posts |
#1
|
|||
|
|||
drop down list question
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 |
#2
|
|||
|
|||
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 -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list | Excel Discussion (Misc queries) | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
formatting drop down list | Excel Discussion (Misc queries) | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
How do you create a drop down list? | Excel Discussion (Misc queries) |