Hi,
I have a table of student schedules that I need to search for any of a long list of different classes (Math 1, Math 2, etc.) in a named range (Math). If the search finds any of the courses from the named range in a student’s schedule it would return what period of the day the student has that class. Students' names are in column 1, while the next 6 columns are periods 1, 2, 3… Is there any easy way to search for these (Math 1, Math 2, Math 3, and another 12) in table like the one below and return the last column? What function or formula would I use to get the last column in the table below? I’ve tried just about everything I can think of. Thanks.
I have a table of student schedules that I need to search for any of a long list of different classes (Math 1, Math 2, etc.) in a named range (Math). If the search finds any of the courses from the named range in a student’s schedule it would return what period of the day the student has that class. Students' names are in column 1, while the next 6 columns are periods 1, 2, 3… Is there any easy way to search for these (Math 1, Math 2, Math 3, and another 12) in table like the one below and return the last column? What function or formula would I use to get the last column in the table below? I’ve tried just about everything I can think of. Thanks.
1 | 2 | 3 | 4 | 5 | 6 | Math Period? | |
Student A | Math 1 | ELA | Spanish 1 | PE | World History | Biology | 1 |
Student B | ELA | PE | Spanish 3 | US History | Math 3 | Chemistry | 5 |
Student C | ELA | TA | Woodshop | Math 2 | Biology | Art | 4 |
Student D | Math 1 | Spanish 1 | PE | Biology | ELA | World History | 1 |