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.