Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup error
100 A 100A 1000 8000
200 B 200B 2000 8000 300 C 300C 3000 8000 100-1 D 100-1D 4000 4000 100-2 E 100-2E 5000 5000 100-3 F 100-3 F 6000 6000 100-4 G 100-4 G 7000 7000 100-5 H 100-5 H 8000 8000 Ok, i have the above data. The first two columns are just text, and the third column is a concatenate function to combine the first two columns. Column 4 is just numbers. Also, column 3 and 4 are a named range, "ni". Column five is a vlookup formula with the following: vlookup(C1, ni, 2). Therefore, E1 should be 1000, but the formula is returning 8000. It seems that the dashes or something is confusing vlookup. Any suggestions around this error? Much appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup() error #n/a | Excel Worksheet Functions | |||
vlookup error | Excel Discussion (Misc queries) | |||
vlookup error | Excel Discussion (Misc queries) | |||
vlookup error na# | Excel Worksheet Functions | |||
Value Not Available Error in Vlookup | Excel Discussion (Misc queries) |