The problem I have is that if Georgia appears in more than one classroom this string only shows the first occurrence, and I want it to show an error because she cannot be in 2 classrooms at once. How do I make it show a FALSE/ERROR value when more than one ISNUMBER(SEARCH is TRUE?
=IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B5)),"6",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B16)),"7",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B27)),"8",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B38)),"10",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B49)),"11",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B60)),"12",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B71)),"1",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B82)),"2",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B93)),"3",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B104)),"14",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B1156)),"15",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B126)),"18",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B137)),"19",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B148)),"26",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B159)),"27",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B170)),"16",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B181)),"17",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B192)),"20",IF(ISNUMBER(SEARCH("Georgia",'[2024 Classroom Timetables.xlsx]Sheet 1'!B203)),"21","ERROR")))))))))))))))))))
Hoping someone can please help.
