problem with numbers in vlookup

M

melawaisi

I am having a problem with vlookup, I am using the vlookup to lookup
table. The problem is that I have values in my lookup_value that ar
C.8, C.80…. And it is mixing things up to see what I men try and creat
an lookup array table with c.80, c.8 and c.08. Thanks for the hel
 
F

Freemini

I assume your table is in the order shown, i.e. c.80, c.8 and c.08 i
this is the case this is where your problem lies. Vlookup only work
when the table is in ascending order, so in your example the orde
should be :
C.08, C.8 and C.80

The way to overcome this is to sort your lookup table, sorting on th
first column in ascending order. This should solve your problem.

Mik
 
A

Arvi Laanemets

Hi


Freemini said:
I assume your table is in the order shown, i.e. c.80, c.8 and c.08 if
this is the case this is where your problem lies. Vlookup only works
when the table is in ascending order, so in your example the order
should be :
Click to expand...

I'm afraid you are wrong here. VLOOKUP behaves so only when 4th parameter is
missing, or it is TRUE. Set it to FALSE, and exact match is searched for,
and no order is needed,
 
P

Paul

melawaisi said:
I am having a problem with vlookup, I am using the vlookup to lookup a
table. The problem is that I have values in my lookup_value that are
C.8, C.80.. And it is mixing things up to see what I men try and create
an lookup array table with c.80, c.8 and c.08. Thanks for the help
Click to expand...

I cannot follow your last sentence! Also, when posting, please quote the
formula you are using.

Is the problem with creating the table or with the operation of the formula?
If it's with creating the table, what is the problem?
If it's the formula, you must either have the table sorted or the last
parameter must be entered as FALSE, like this:
=VLOOKUP(C1,A1:B3,2,FALSE)
 
M

melawaisi

thanks for the help, I seem to have got the first method working until,
I notcied it is bringing up the wrong values, I attach the file, which
has 2 sheets, sheets 2 is where I do the lookup, Column G is where the
equation is.


+----------------------------------------------------------------+
| Attachment filename: lightcontrol.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=356386|
+----------------------------------------------------------------+
 
M

melawaisi

the particular one that i spotted is G90.

G053 LCM9 1 CO.14 3 GS06 50 150 0.65


the value it is bringing is 50 while it should be 180!!

Thanks for the hel
 
Top