Home |
Search |
Today's Posts |
#1
|
|||
|
|||
=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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Instead of RIGHT(some_cell,1), use this variation:
--RIGHT(some_cell,1) (that's 2 minus signs in front) Does that hellp? Ron |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |