=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
|