=right and =vlookup
 

Hello -

I've extracted the right character from a list of prices ($12.99 my result
is 9). Now when I do a vlookup using a table array in which I have typed
1-9, I get N/A instead of the result column to which I point. I've tried
changing all of the formats to number, general, and text, but I can't seem to
get it.

Thanks for any help.

Marc

Marc,

It is probably because you are now comparing a text value to a numeric
value. Try converting the lookup value, something like

=VLOOKUP(VALUE(B14),E14:F16,2,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Marc" wrote in message
...
Hello -

I've extracted the right character from a list of prices ($12.99 my result
is 9). Now when I do a vlookup using a table array in which I have typed
1-9, I get N/A instead of the result column to which I point. I've tried
changing all of the formats to number, general, and text, but I can't seem
to
get it.

Thanks for any help.

Marc

Instead of RIGHT(some_cell,1), use this variation:
--RIGHT(some_cell,1)

(that's 2 minus signs in front)

Does that hellp?

Ron

Ron -

Both your and Bob's suggestions work! I appreciate the quick feedback.

Marc

"Ron Coderre" wrote:

Instead of RIGHT(some_cell,1), use this variation:
--RIGHT(some_cell,1)

(that's 2 minus signs in front)

Does that hellp?

Ron

Bob -
Both you and Ron gave excellent, working suggestions. Thank you very much.
Marc

"Bob Phillips" wrote:

Marc,

It is probably because you are now comparing a text value to a numeric
value. Try converting the lookup value, something like

=VLOOKUP(VALUE(B14),E14:F16,2,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Marc" wrote in message
...
Hello -

I've extracted the right character from a list of prices ($12.99 my result
is 9). Now when I do a vlookup using a table array in which I have typed
1-9, I get N/A instead of the result column to which I point. I've tried
changing all of the formats to number, general, and text, but I can't seem
to
get it.

Thanks for any help.

Marc