Why doesn't this VLOOKUP work?
Author Message
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 61-65, 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
> (XX-YY).

> tia

> Norm

Wed, 18 Jun 1902 08:00:00 GMT
Why doesn't this VLOOKUP work?
Why doesn't this work? I'm using xl97. The contents of A14
is 61-65, 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
(XX-YY).

tia

Norm

Wed, 18 Jun 1902 08:00:00 GMT
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
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 61-65, 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
> (XX-YY).

> tia

> Norm

--
Posted via CNET Help.com
http://www.help.com/

Wed, 18 Jun 1902 08:00:00 GMT
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 61-65, 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
:> (XX-YY).
:>
:> tia
:>
:> Norm

Wed, 18 Jun 1902 08:00:00 GMT

 Page 1 of 1 [ 5 post ]

Relevant Pages