How about:

=VLOOKUP(B2,SHEET2!A1:A100,2,FALSE)

Let me know if that works