If your lookup table has codes which are all formatted as text values (including those that are pure numbers), then you can write your VLOOKUP formula as:

=VLOOKUP(A2&"", ...

which will convert the lookup_value in A2 into text.

Hope this helps.