Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |