I suspect a VLOOKUP will do what you want if you:

Put this forumula in Cell C4 and copy it down:
=VLOOKUP(B4,Sheet2!$B$3:$C$11,2,0)

I hope that helps.

Regards,
Ron