The problem that I'm getting when using the vlookup is that the only answer
that I get is the formula it self. As I am entering the formula in the
dialogue box, the dialogue box displays the correct value but when I click
OK, it returns the formula instead of the correct value.

The format on both columns are the same. Any help would be greatly
appreciated.