what formula do I use if I want to check if A given value on worksheet A, exists on worksheet B?

I *thought* something like this would work, but I can't figure out what I'm doing wrong-

=IF((S2=Vlookup(S2,'MC'!$A$2:$B$200,2),"Yes"," ")

thanks in advance!