Vlookup help

[GOKULA]

Can anyone help me with this. One of my sheets has info on student ID and the class they were in last year. The new sheet has the student id and the class they are enrolled in this year. If they both don't match it should say bad. Sheet two should look like the table below. The range is H2:P1854, H is the ID Column, P is the class Column(for both sheets)

ID	Class	Verification
1234566	Math	=IF(VLOOKUP(H2,'2018 Classes Roster'!$H$2:$P$1854,6,FALSE)=0,"bad","good")​
3423443	Math	Good
3422342	Science	Bad
8978989	Science	Bad

<tbody>
</tbody>

 

[Fluff]

How about
=IF(VLOOKUP(H2,'2018 Classes Roster'!$H$2:$P$1854,6,FALSE)<>P2,"bad","good")

 

[GOKULA]

Thanks for the fast response! When I change the class from science to math, it's still returning good.

 

[Fluff]

How about
=IF(VLOOKUP(H2,'2018 Classes Roster'!$H$2:$P$1854,9,FALSE)<>P2,"bad","good")

 

[GOKULA]

How about
=IF(VLOOKUP(H2,'2018 Classes Roster'!$H$2:$P$1854,9,FALSE)<>P2,"bad","good")

i made a typo at the start, P is not the class class, M is the class column,

Do i have to select the entire table from the sheet? or can i just select the needed columns??

 

[Fluff]

You can do it like
=IF(VLOOKUP(H2,'2018 Classes Roster'!$H$2:$M$1854,6,FALSE)<>P2,"bad","good")

As long as the last row of the lookup table is row 1854 or less.

 

[GOKULA]

i changed p2 to m2 .....It works now...thank you!!!

 

[Fluff]

You're welcome & thanks for the feedback

 

[GOKULA]

This the first sheet

Student ID	Course ID Fall
M82922929	A&S 001
M68669689	A&S 012
M78666687	A&S 035
M28262728	A&S 055

<tbody>
</tbody>

You have helped me create 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>

 

[Fluff]

As this is now a totally different question, you will need to start a new thread, thanks.