Trouble with Vlookup
 

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?

Trouble with Vlookup
 

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


"Hawksby" skrev i meddelelsen
...
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?

Trouble with Vlookup
 

Try, which worked for me.

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


Regards,
Howard

"Per Jessen" wrote in message
...
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


"Hawksby" skrev i meddelelsen
...
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?