vLookup
Are you sure, Gord? I think it's doublequote D doublequote singlequote s,
so the D surrounded with double quotes, and then apostrophe s presumably
intended to make it become a plural.
--
David Biddulph
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
In your posted example you have doublequote D singlequote doublequote
Does your data have the double or single quotes?
Gord Dibben MS Excel MVP
On Mon, 18 Jan 2010 11:03:01 -0800, Marcon
wrote:
For some reason, I am having a problem with certain characters (letters)
that
are not being read properly in a vLookup table. Right now I am having a
problem with the letter D - I have certain items designated as "D"'s, and
after I have created the table, it's not returning the value. I am
getting
"#N/A" returned. The other characters are working fine. Any thoughts?
Thanks.
|