Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup issue
Hello,
I have a file with two sheets. One the second sheet, I am using a vlookup to find values in the first sheet. Simple enough. However, I came across a unique problem that I have never encountered. The result I recieved was #n/a. Now, the value does exist from both sheets, even using the find function, it works. When I copied the value from the first sheet to the second sheet, it returns a valid value, not #n/a. I don't understand why? As you can in this example, the 15 digit numbers are the same, but produces two different answers. They should be the same! Format should have nothing to do with it, correct? I hope that this is simple for you to answer. 330000050001068 1.00% 4 (I copied the 15 digit from sheet 1) 330000050001068 #N/A #N/A (Originial 15 digit value from sheet 2) Help Please. MrRJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup issue | Excel Worksheet Functions | |||
Vlookup issue | Excel Discussion (Misc queries) | |||
Vlookup issue | Excel Discussion (Misc queries) | |||
VLOOKUP issue | Excel Worksheet Functions | |||
am not sure if its a vlookup issue | Excel Discussion (Misc queries) |