So, here's my issue. I've got three sheets. One sheet has all of the classes for Mondays and Wednesdays, one sheet has all the classes for Tuesdays and Thursdays. The third sheet has a drop-down menu in cell A1 with a list of all of the classes. By putting the in the following formula, I was able to make it so that the "Student Name" column populates with the corresponding information from the correct sheet:
=IF(A1="Character Education", ARRAYFORMULA('Mon/Wed'!A:A), IF(A1="Biology", ARRAYFORMULA('Mon/Wed'!D:D), IF(A1="English A", ARRAYFORMULA('Mon/Wed'!G:G), IF(A1="English B", ARRAYFORMULA('Mon/Wed'!J:J), IF(A1="English C", ARRAYFORMULA('Mon/Wed'!M:M), If(A1="History", ARRAYFORMULA('Tu/Th'!A:A), IF(A1="Math A", ARRAYFORMULA('Tu/Th'!D:D), IF(A1="Math B", ARRAYFORMULA('Tu/Th'!G:G), If(A1="Math C", ARRAYFORMULA('Tu/Th'!J:J), IF(A1="Spanish", ARRAYFORMULA('Tu/Th'!M:M)))))))))))
However, while it does populate the column accordingly, it does not make it so that you can edit the data as well.
My goal: Make it so that instead of scrolling through the sheets to find the class, you can just click the drop down, have only that class display, and then be able to edit the information of that class. Alternative solution: hiding/displaying groups of columns based on drop-down value. Make sense?
Best Answer
Instead of using drop-downs from data validation and formulas put all the information in a single sheet and use filters or filters views. For details see the official help article Filter your data - Docs editors Help