View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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?