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!
Bookmarks