I am trying to set a simple spreadsheet to track attendance at a conference.
What I would like to do is to be able to pull up a students school
affiliation by school or by chapter. I would like two drop down boxes and
have either of them trigger the correct match in the other one. An example:
Joe Smith attends Ohio State and is a member of Alpha Xi Chi. I would like
to be able to click on Ohio State in the school field and have Alpha Xi Chi
show up in the chapter field, or click on Alpha Xi Chi in the chapter field
and have Ohio State show up in the school field. Is this possible? I can set
up the drop downs, but is there a way to link them up?