我遇到的问题是，如果 Georgia 出现在多个教室中，此字符串仅显示第一次出现，我希望它显示错误，因为她不能同时出现在 2 个教室中。当多个 ISNUMBER(SEARCH 为 TRUE 时，如何让它显示 FALSE/ERROR 值？
=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时间表.xlsx]表 1'!B60)),"12",IF(ISNUMBER(SEARCH("佐治亚州",'[2024 课堂时间表.xlsx]表 1'!B71)),"1",IF(ISNUMBER(SEARCH("佐治亚州",'[2024 课堂时间表.xlsx]表 1'!B82)),"2",IF(ISNUMBER(SEARCH("佐治亚州",'[2024 课堂时间表.xlsx]表 1'!B93)),"3",IF(ISNUMBER(SEARCH("佐治亚州",'[2024 课堂时间表.xlsx]表 1'!B104)),"14",IF(ISNUMBER(SEARCH("佐治亚州",'[2024 课堂时间表.xlsx]表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")))))))))))))))))))
希望有人可以帮忙。