I need to combine three sheets in a way that is not "merge" or "concatenation". I have done this before, but I can't remember the command!
The set-up: I have three sheets with related data on three levels. Eg: sheet #1.) data on schools, sheet #2.) data on teachers (who may teach at more than one school), and sheet #3.) data on students. The data on students has variables that identify both the school and the teacher that that student is in (or has).
The question: So, how can I get the appropriate school and teacher variables matched up to the right students into my student data sheet (sheet #3)?
I know that this is a simple question for someone, but I just can't get it done. Thanks a lot!
Chris
Bookmarks