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.
EDITED: 16 Nov 2011 14:27 by PILOTDAN