This is the first sheet
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Student ID[/TD]
[TD]Course ID Fall[/TD]
[/TR]
[TR]
[TD]M82922929[/TD]
[TD]A&S 001[/TD]
[/TR]
[TR]
[TD]M68669689[/TD]
[TD]A&S 012[/TD]
[/TR]
[TR]
[TD]M78666687[/TD]
[TD]A&S 035[/TD]
[/TR]
[TR]
[TD]M28262728[/TD]
[TD]A&S 055[/TD]
[/TR]
</tbody>[/TABLE]
i got help creating a formula that would identify a mismatch happening.
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Student ID[/TD]
[TD]Course ID Spring[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]M82922929[/TD]
[TD]A&S 001[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]M68669689[/TD]
[TD]A&S 013[/TD]
[TD]Bad[/TD]
[/TR]
[TR]
[TD]M78666687[/TD]
[TD]A&S 029[/TD]
[TD]Bad[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]M28262728[/TD]
[TD]A&S 045[/TD]
[TD]Bad
[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Course ID fall[/TD]
[TD]Course ID spring[/TD]
[/TR]
[TR]
[TD]A&S 001[/TD]
[TD]A&S 001[/TD]
[/TR]
[TR]
[TD]A&S 012[/TD]
[TD]A&s 013[/TD]
[/TR]
[TR]
[TD]A&S 035[/TD]
[TD]A&S 029[/TD]
[/TR]
[TR]
[TD]A&S 055[/TD]
[TD]A&S 025, 065, 045[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Student ID[/TD]
[TD]Course ID Fall[/TD]
[/TR]
[TR]
[TD]M82922929[/TD]
[TD]A&S 001[/TD]
[/TR]
[TR]
[TD]M68669689[/TD]
[TD]A&S 012[/TD]
[/TR]
[TR]
[TD]M78666687[/TD]
[TD]A&S 035[/TD]
[/TR]
[TR]
[TD]M28262728[/TD]
[TD]A&S 055[/TD]
[/TR]
</tbody>[/TABLE]
i got help creating a formula that would identify a mismatch happening.
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Student ID[/TD]
[TD]Course ID Spring[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]M82922929[/TD]
[TD]A&S 001[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]M68669689[/TD]
[TD]A&S 013[/TD]
[TD]Bad[/TD]
[/TR]
[TR]
[TD]M78666687[/TD]
[TD]A&S 029[/TD]
[TD]Bad[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]M28262728[/TD]
[TD]A&S 045[/TD]
[TD]Bad
[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Course ID fall[/TD]
[TD]Course ID spring[/TD]
[/TR]
[TR]
[TD]A&S 001[/TD]
[TD]A&S 001[/TD]
[/TR]
[TR]
[TD]A&S 012[/TD]
[TD]A&s 013[/TD]
[/TR]
[TR]
[TD]A&S 035[/TD]
[TD]A&S 029[/TD]
[/TR]
[TR]
[TD]A&S 055[/TD]
[TD]A&S 025, 065, 045[/TD]
[/TR]
</tbody>[/TABLE]