Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get info filled in automatically
I make a roster for my work with multiple items for each person. An example
of what I am looking to do: In cell A1, I have a drop down menu with all employee's names. Cell B1 is for their ID number and cell C1 is for their radio ID #. I wanted to see if their was a way for when I select a name in the drop down menu of A1 for B1 and C1 to automatically fill with that employees' respective ID numbers? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get info filled in automatically
Hi
Let's say you have a list of employees with their relevant numbers on Sheet2 in cells A2:Cxxx With your dropdown list in cell A2 of Sheet1, enter the following in B2 =if(A2="","",VLOOKUP(Sheet2!$A:$C,$A2,COLUMN(B2),0 )) copy the formula across to cell C2 and then copy B2:C2 down the page as far as required -- Regards Roger Govier "slgs_13" wrote in message ... I make a roster for my work with multiple items for each person. An example of what I am looking to do: In cell A1, I have a drop down menu with all employee's names. Cell B1 is for their ID number and cell C1 is for their radio ID #. I wanted to see if their was a way for when I select a name in the drop down menu of A1 for B1 and C1 to automatically fill with that employees' respective ID numbers? __________ Information from ESET Smart Security, version of virus signature database 4799 (20100123) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4799 (20100123) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get info filled in automatically
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "slgs_13" wrote in message ... I make a roster for my work with multiple items for each person. An example of what I am looking to do: In cell A1, I have a drop down menu with all employee's names. Cell B1 is for their ID number and cell C1 is for their radio ID #. I wanted to see if their was a way for when I select a name in the drop down menu of A1 for B1 and C1 to automatically fill with that employees' respective ID numbers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to keep a running tally of boxes filled with info | Excel Worksheet Functions | |||
Filled cells dont appear as filled | Excel Discussion (Misc queries) | |||
How do I avoid fields being automatically filled in by default? | New Users to Excel | |||
how do I update a sheet automatically with the info from another? | New Users to Excel | |||
I need formula that will automatically count the filled cells. | Excel Discussion (Misc queries) |