This is the first sheet
<tbody>
</tbody>
i got help creating a formula that would identify a mismatch happening.
<tbody>
</tbody>
<tbody>
</tbody>
If it shows up bad, i want a formula that would look up another sheet( that looks like below). If fall course was A&S 012 and if then Spring class is A&S 013 it should return good. Similarly for the A&S 045, if the spring course id is any of the 3 in the last row and the fall id was A&S 055, it should return good.
<tbody>
</tbody>
Student ID | Course ID Fall |
M82922929 | A&S 001 |
M68669689 | A&S 012 |
M78666687 | A&S 035 |
M28262728 | A&S 055 |
<tbody>
</tbody>
i got help creating a formula that would identify a mismatch happening.
Student ID | Course ID Spring | Status |
M82922929 | A&S 001 | Good |
M68669689 | A&S 013 | Bad |
M78666687 | A&S 029 | Bad |
<tbody>
</tbody>
M28262728 | A&S 045 | Bad |
<tbody>
</tbody>
If it shows up bad, i want a formula that would look up another sheet( that looks like below). If fall course was A&S 012 and if then Spring class is A&S 013 it should return good. Similarly for the A&S 045, if the spring course id is any of the 3 in the last row and the fall id was A&S 055, it should return good.
Course ID fall | Course ID spring |
A&S 001 | A&S 001 |
A&S 012 | A&s 013 |
A&S 035 | A&S 029 |
A&S 055 | A&S 025, 065, 045 |
<tbody>
</tbody>