You could use a helper cell:

=isnumber(match(b2,'a2'!b:b,0))

and drag down.

You'll see Trues if there's a match.  Falses if none.

I'm not sure what you'll do next.

But if you really don't care if there's a match, maybe =vlookup() will work for
you.

Debra Dalgleish has some nice notes for getting started with =vlookup() at:
http://www.contextures.com/xlFunctions02.html