vLookup

[Marcon]

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.

 

[trip_to_tokyo]

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.

 

[trip_to_tokyo]

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.

 

[Gord Dibben]

In your posted example you have doublequote D singlequote doublequote

Does your data have the double or single quotes?


Gord Dibben MS Excel MVP

 

[David Biddulph]

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.

 

[Niek Otten]

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

 

[Gord Dibben]

I think you are right David.

Just too many years on these eyes<g>


Gord

 

[David Biddulph]

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.