Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Validation Drop down list to Autofill next column
Hi there!
I've been googling for the last 2 weeks trying to find the easiest way to create my worksheet - however i can't find much info. Basically what I want to create is Column 1 = Names of people Column 2 = Team Leaders Column 3 = Department There won't be an end to this sheet (so 1 sheet per year) I have created 2 worksheet - 1 is called Log the other is Datas What I want to happen is use the drop down list of names of people ( which I was able to create - by using data validation (that was easy). Now the hard bit is, when I pick a name from the drop down list and I want their Team Leader to auto fill column 2 and on column 3 to auto fill their department. I'm not sure if this is a Vlookup. It just seems so hard to figure out. If you know how to create this work sheet = please let me know. Your feedback would be appreciated. Please be aware I'm UBER newbie w/ excel |
#2
|
|||
|
|||
Quote:
yes, you are on the right track. Data validation and vlookup fetches the data as per your requirement. refer to attached sheet, i made some sample data for you. all the best
__________________
Thanks Bala |
#3
|
|||
|
|||
Thanks for replying back. Your spreadsheet is exactly what I want. I don't know how you did it. Will you be able to show me a step by step guide. I got the drop down list through validation however I don't know how to use Vlookup. Your work is appreciated. Thanks
|
#4
|
|||
|
|||
Quote:
Hi, Say you have raw data in Col E, F & G(8 rows for ex.) in the same sheet or another sheet(depending on your requirement). Create a drop down list of Name in Cell A1. Select any name from the drop down. In Cell B1 write this formula =+VLOOKUP($A$1,$E$1:$G$8,2,0). This will fetch the Team leader name for the selected employee. In Cell C1 write this formula =+VLOOKUP($A$1,$E$1:$G$8,3,0). This will fetch the corresponding department. Both Team Leader and Department will change depending on the chosen employee in the drop down list. |
#5
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation - drop down list | Charts and Charting in Excel | |||
Data Validation with Drop-down list | Excel Worksheet Functions | |||
DROP DOWN LIST DOES NOT APPEAR USING DATA VALIDATION | Excel Discussion (Misc queries) | |||
Drop down list in Data Validation | Excel Discussion (Misc queries) | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel |