#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
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?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 698
Default 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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trouble with vLookup lcks via OfficeKB.com New Users to Excel 1 June 7th 06 09:23 AM
big trouble with combobox/vlookup soulfear Excel Discussion (Misc queries) 1 May 11th 06 07:55 AM
Trouble with a VLOOKUP formula WhytheQ Excel Worksheet Functions 9 March 14th 06 03:27 AM
Having trouble with vlookup and match ADiscrete1 Excel Worksheet Functions 8 November 17th 05 03:09 AM
VLOOKUP trouble .. HELP! Dylan Moran Excel Worksheet Functions 2 December 7th 04 08:25 AM


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"