Trouble with Vlookup

[Hawksby]

Afternoon all,

I have a field of text which is starts with a number and basically what i'm
tring to do is use this number in a vlookup to return a value in another cell.

The fomula that i'm using is =vlookup(left(A1,1),Range of table,2,False)

The problem seems to be with the way in which the fomula is treating the
value from the left part of the formula. Does anyone know how i can get
around this?

 

[Per Jessen]

Hi

As Left() function is a text function, it return a string, so you need to
convert the result to a value:

=vlookup(Value(left(A1,1)),Range of table,2,False)

Regards,
Per

 

[L. Howard Kittle]

Try, which worked for me.

=vlookup(Value(left(A1,1)*1,Range of table,2,False)


Regards,
Howard