vLookup
 

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.

vLookup
 

Marcon:-

I think that there is a genuine MS bug here because I discussed this topic
with somebody else a few days ago.

I will post the results of my testing (showing that the software is wrong)
on my website in the next 30 minutes or so.

It was the same issue that you are seeing (returning #N/A) when you were
expecting soemthing else.



"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.

vLookup
 

I have just re-tested this.

Double check the following points:-

1. Make sure that the range in your LOOKUP is fixed, for example:-

=VLOOKUP(F16,$B$2:$L$5,11,FALSE)

In the above:-

$B$2:$L$5

- is, €œfixed€�.

If it is not, €œfixed€� this may be giving you the problem that you are
experiencing.

2. Check the format of the cells you are working with.

If you are looking for an Employee Number ID, for example, make sure that
that is formatted as General in both the, €œsource data€� and the VLOOKUP table
itself.

If they are formatted differently this may give rise to the problem that you
are experiencing.

3. If you want me to test further you need to give me some more details
about your, €œsource data€� and what you are trying to look up and return.



"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.

vLookup
 

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.

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.

vLookup
 

<I will post the results of my testing (showing that the software is wrong)
on my website in the next 30 minutes or so.

URL?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"trip_to_tokyo" wrote in message
...
Marcon:-

I think that there is a genuine MS bug here because I discussed this topic
with somebody else a few days ago.

I will post the results of my testing (showing that the software is wrong)
on my website in the next 30 minutes or so.

It was the same issue that you are seeing (returning #N/A) when you were
expecting soemthing else.



"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.

vLookup
 

I think you are right David.

Just too many years on these eyes<g


Gord

On Mon, 18 Jan 2010 20:51:36 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

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.

vLookup
 

My excuse is to blame the quality of this screen, rather than my ancient
eyes. :-(
The only way I could be sure was to copy from the message, and then delete a
character at a time.
--
David Biddulph

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I think you are right David.

Just too many years on these eyes<g


Gord

On Mon, 18 Jan 2010 20:51:36 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

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.