Hi Gaveon,

Try adding a new column that multiplies your value by 1.

So the Formula for a value in 'A2' would be;

=A2*1

This will convert it into a number.

Do this to both & the VLOOKUP should work.

Hth