nicolai185
New Member
- Joined
- Dec 8, 2011
- Messages
- 49
Hello!
I am attempting to create multiple drop down lists where the second box is dependent on the values entered into the first. I know this has been done before, but this may be somewhat unique.
Essentially, I want users to select a value from the first list (in this case, teacher name) and I want the second list to populate a list of just their students (not the whole school). There are 100 teachers and I want to figure out a way that I can use vlookup to reference the first list and populate a named range that i can reference for the second list.
I would prefer not to use a macro if possible, but I'm not super familiar with them. This document will need to be emailed to various teachers who have Excel 2007 and a few with macs.
Any help would be GREAT! Thanks
Nick
I am attempting to create multiple drop down lists where the second box is dependent on the values entered into the first. I know this has been done before, but this may be somewhat unique.
Essentially, I want users to select a value from the first list (in this case, teacher name) and I want the second list to populate a list of just their students (not the whole school). There are 100 teachers and I want to figure out a way that I can use vlookup to reference the first list and populate a named range that i can reference for the second list.
I would prefer not to use a macro if possible, but I'm not super familiar with them. This document will need to be emailed to various teachers who have Excel 2007 and a few with macs.
Any help would be GREAT! Thanks
Nick