excel_user_1966
New Member
- Joined
- Mar 24, 2002
- Messages
- 7
ok, i've got a drop down list box with things in it like Student1, Student2, Student3, etc etc..
When someone selects a name from this list, it puts the name last selected into a cell in excel.
I would like to know how to make it so that rather than write Student1, Student2 etc or whatever is selected into ONE specific cell, i want it to write either Yes or No into the column next to the selected student's name.
thanks for any help with this..
BTW, i've tried doing it with numbers... writing 1,2,3,4 etc. by their names, and then using vlookup etc as someone else suggested, but this isn't possible due to something i can't be bothered to explain now... just blieve me when i tell you i can't do it like that
When someone selects a name from this list, it puts the name last selected into a cell in excel.
I would like to know how to make it so that rather than write Student1, Student2 etc or whatever is selected into ONE specific cell, i want it to write either Yes or No into the column next to the selected student's name.
thanks for any help with this..
BTW, i've tried doing it with numbers... writing 1,2,3,4 etc. by their names, and then using vlookup etc as someone else suggested, but this isn't possible due to something i can't be bothered to explain now... just blieve me when i tell you i can't do it like that