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  
 
 [ 5 post ] 

 Relevant Pages 

1. Why doesn't this work...Newbie at work

2. WHY DOESN'T IT Work AT WORK

3. Grouping query doesn't work - don't know why

4. Why OR'ing doesn't work in my formula

5. Vlookup doesn't work in VBA?

6. Vlookup doesn't work in my situtation.

7. vlookup doesn't work?

8. Vlookup doesn't work

9. why doesn't this code work?

10. Rules Wizard... why doesn't it work


 
Powered by phpBB® Forum Software © phpBB Group