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?
|