Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel drop down lists
I am trying to make a drop down list that has three types of information.
Name, Employee Number and Record Number. Which I have done but my problem is this. When the employee chooses his name from the drop down box, I need Column A1 to have ONLY the name, Column B1 to have ONLY the employee number and Column C1 to have ONLY the record number but I need this to happen all at once and not by creating three seperate drop down lists as employees will not know their record number. The reason is that I have "Transpose" functions that are reading off of A1, B1 and C1 and transposing that information onto other sheets in my workbook. Is there a function that can read off of the cell with the drop down list and then split the 3 forms of information up between the 3 respective cells? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel drop down lists
Create a table of name, employee number, and record number.
Add Data Validation to A1 and point it to the name column of the table. In B1, add =VLOOKUP(A1,employee_table,2,False) In C1, add =VLOOKUP(A1,employee_table,3,False) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "GHOSTRO" wrote in message ... I am trying to make a drop down list that has three types of information. Name, Employee Number and Record Number. Which I have done but my problem is this. When the employee chooses his name from the drop down box, I need Column A1 to have ONLY the name, Column B1 to have ONLY the employee number and Column C1 to have ONLY the record number but I need this to happen all at once and not by creating three seperate drop down lists as employees will not know their record number. The reason is that I have "Transpose" functions that are reading off of A1, B1 and C1 and transposing that information onto other sheets in my workbook. Is there a function that can read off of the cell with the drop down list and then split the 3 forms of information up between the 3 respective cells? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel drop down lists
Thanks Bob,
That is exactly what I needed!! "Bob Phillips" wrote: Create a table of name, employee number, and record number. Add Data Validation to A1 and point it to the name column of the table. In B1, add =VLOOKUP(A1,employee_table,2,False) In C1, add =VLOOKUP(A1,employee_table,3,False) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "GHOSTRO" wrote in message ... I am trying to make a drop down list that has three types of information. Name, Employee Number and Record Number. Which I have done but my problem is this. When the employee chooses his name from the drop down box, I need Column A1 to have ONLY the name, Column B1 to have ONLY the employee number and Column C1 to have ONLY the record number but I need this to happen all at once and not by creating three seperate drop down lists as employees will not know their record number. The reason is that I have "Transpose" functions that are reading off of A1, B1 and C1 and transposing that information onto other sheets in my workbook. Is there a function that can read off of the cell with the drop down list and then split the 3 forms of information up between the 3 respective cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Drop Down Lists | Excel Worksheet Functions | |||
Excel Drop Down Lists Help | Excel Worksheet Functions | |||
Drop down lists in excel | Excel Discussion (Misc queries) | |||
Excel Drop-down lists | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |