Your column B in the example looks to be numeric to me (right aligned),
but column D doesn't, although it is difficult to say exactly with how
the table is misaligned. You could try the following amendment to your
lookup formula:

=vlookup(VALUE(d2),b:c,2,0)

Hope this helps.

Pete