To clarify - it's because your lookup value is text, and your lookup table are numbers. You need to search like for like.

Edit: This doesn't seem to be entirely true, but I can't be bothered to investigate it further. However, the root cause is as above.