In the same document, I have one sheet with schedules per school and another with schedules per teacher. I want to change the sheet with the school schedules (choosing a teacher for a certain class on a given day), that the sheet with the teachers' schedules also be changed (adding this class in the teacher's schedule).
At this point I have this:
=IFERROR(QUERY(Escolas!$A$1:$F$14; "Select A Where B="B1""; 0);"")
Escolas!
is the name of the sheet where the times are per school.
A
is the column where the classes are.
B
is the column where I choose the time for this class.
B1
is the cell where the teacher's time code is located
If instead of B1
put text (for example the time code 'EX1'), it works. But with reference to a cell (even by detecting that cell, it gives a Formula parse error ).