Odd VLOOKUP failure

Hi all,

I am trying to lookup some values from a table on a different sheet. I've used VLOOKUP before and never had any issues with it. But now, for some of the lookup values, I get a N/A error. I've checked to make sure that the numbers are indeed numbers: 1) by recreating both lookup values and the table values on a different column and pasting the values 2) by multiplying the values by 1.

I just don't get it. I'm beginning to suspect a bug in Excel which if it exists would be very catastrophic. Am I missing something or is there something wrong with excel or my workbook?

Regards,
Ali