Hello,
I work for a hospital school teaching students who are too ill, physically or mentally to go into school. Our remote teaching team is continually growing and we're trying to create a better system of centeralising staff and student timetables.
I was wondering if someone could tell me if the following is possible and what functions I need to learn in order to make it work......
I'd like to complete the top table 'staff timetable', by imputting students initials and the bottom 'student timetable' to automatically update with the staff initial. I've tried using the lookup function but found it didn't identify if a student was double booked it just returns the last teachers initials. There are also occasions where small groups are taught and I couldnt get the lookup function to find TG (for example) if the cell had TG & TS.
I'm a complete newbie so any help would be greatly appreciated!
Thanks
I work for a hospital school teaching students who are too ill, physically or mentally to go into school. Our remote teaching team is continually growing and we're trying to create a better system of centeralising staff and student timetables.
I was wondering if someone could tell me if the following is possible and what functions I need to learn in order to make it work......
I'd like to complete the top table 'staff timetable', by imputting students initials and the bottom 'student timetable' to automatically update with the staff initial. I've tried using the lookup function but found it didn't identify if a student was double booked it just returns the last teachers initials. There are also occasions where small groups are taught and I couldnt get the lookup function to find TG (for example) if the cell had TG & TS.
I'm a complete newbie so any help would be greatly appreciated!
Thanks