Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup returns value in the adjacent row
I am trying to use the vlookup function and it is returning the value in the
cell in the row just above the appropriate value in the table I am searching. For example, when my lookup_value corresponds to A3 (in the table below), the function is returning B2: A1 B1 A2 B2 A3 B3 A4 B4 Just in case this matters, the array has been copied from Access (but it's in an Excel worksheet). Also, the values in the lookup column are in 2 forms (#1 form 123456, #2 form 234-567). I have tried converting everything to text and to general numbers but it doesn't seem to help. Any help would be appreciated. Bran |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
Vlookup returns a zero? | Excel Discussion (Misc queries) | |||
problem with Vlookup in macro | Excel Discussion (Misc queries) | |||
vlookup returns list? | Excel Worksheet Functions | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions |