Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with vLookup | New Users to Excel | |||
big trouble with combobox/vlookup | Excel Discussion (Misc queries) | |||
Trouble with a VLOOKUP formula | Excel Worksheet Functions | |||
Having trouble with vlookup and match | Excel Worksheet Functions | |||
VLOOKUP trouble .. HELP! | Excel Worksheet Functions |