Why doesn't this VLOOKUP work?
Author 
Message 
Chip Pearso #1 / 5

Why doesn't this VLOOKUP work?
Norm, I suspect that Excel is getting "confused" because RIGHT is returning a string value, and your values in G4:G85 are numeric. Convert the lookup value to a numeric, and all should be right with the world. =VLOOKUP(VALUE(RIGHT(A14,2)),$G$4:$N$85,2,FALSE)  Cordially, Chip Pearson Microsoft MVP  Excel Pearson Software Consulting Services
Quote: > Why doesn't this work? I'm using xl97. The contents of A14 > is 6165, which is formatted as general. > =VLOOKUP(right(A14,2),'9900'!$G$4:$N$85,2,FALSE) > The value in A14 will change, but always keep the format of > (XXYY). > tia > Norm

Wed, 18 Jun 1902 08:00:00 GMT 


Norm #2 / 5

Why doesn't this VLOOKUP work?
Why doesn't this work? I'm using xl97. The contents of A14 is 6165, which is formatted as general. =VLOOKUP(right(A14,2),'9900'!$G$4:$N$85,2,FALSE) The value in A14 will change, but always keep the format of (XXYY). tia Norm

Wed, 18 Jun 1902 08:00:00 GMT 


Norm #3 / 5

Why doesn't this VLOOKUP work?
Thanks Chip, that worked perfectly! On Fri, 3 Mar 2000 23:16:03 0600, "Chip Pearson"
:Norm, : :I suspect that Excel is getting "confused" because RIGHT is returning a :string value, and your values in G4:G85 are numeric. Convert the lookup :value to a numeric, and all should be right with the world. : :=VLOOKUP(VALUE(RIGHT(A14,2)),$G$4:$N$85,2,FALSE)

Wed, 18 Jun 1902 08:00:00 GMT 


Coutc #4 / 5

Why doesn't this VLOOKUP work?
Hi Norm: I'm guessing the values in $G in the array are 2 digit numbers. If so, the RIGHT() function will return a string. Add Value() to change the string to a number. By changing the vlookup() as follows, thing may work. =VLOOKUP(VALUE(right(A14,2)),'9900'!$G$4:$N$85,2,FALSE) Have Fun Quote:
> Why doesn't this work? I'm using xl97. The contents of A14 > is 6165, which is formatted as general. > =VLOOKUP(right(A14,2),'9900'!$G$4:$N$85,2,FALSE) > The value in A14 will change, but always keep the format of > (XXYY). > tia > Norm
 Posted via CNET Help.com http://www.help.com/

Wed, 18 Jun 1902 08:00:00 GMT 


Oh N #5 / 5

Why doesn't this VLOOKUP work?
Yep, $G are two digit numbers. It works fine when I add the VALUE part. Thanks On Sun, 05 Mar 2000 04:30:08 GMT, Coutch
:Hi Norm: : :I'm guessing the values in $G in the array are 2 digit numbers. If so, :the RIGHT() function will return a string. :Add Value() to change the string to a number. :By changing the vlookup() as follows, thing may work. : :=VLOOKUP(VALUE(right(A14,2)),'9900'!$G$4:$N$85,2,FALSE) : :Have Fun :
:> :> Why doesn't this work? I'm using xl97. The contents of A14 :> is 6165, which is formatted as general. :> :> =VLOOKUP(right(A14,2),'9900'!$G$4:$N$85,2,FALSE) :> :> The value in A14 will change, but always keep the format of :> (XXYY). :> :> tia :> :> Norm

Wed, 18 Jun 1902 08:00:00 GMT 


