Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Reading Wrong Record
VLOOKUP does not point to the correct row inconsistently. There is a
response difference when naming an array versus identifying the array explicitly; there is a difference when shuffling the order of records; there is even a difference when transposing just the lookup value! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Reading Wrong Record
HI
I don't see your layout but your formula VLOOKUP(A2,C2:F80,2,TRUE) If range_lookup is TRUE, the values in the first column of table_array must be placed in ascending order: 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise VLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted, and will give you the exact answer. HTH John "Spock of Vulcan" <Spock of wrote in message ... VLOOKUP does not point to the correct row inconsistently. There is a response difference when naming an array versus identifying the array explicitly; there is a difference when shuffling the order of records; there is even a difference when transposing just the lookup value! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Reading Wrong Record
Hi,
If its returning the wrong results its because its not being implimented correctly, unfortunately, you aren't showing us you data. What you should do is show us sample data, show us the formula you are using, tell us what results you are getting and when you want. Maybe your data needs to be sorted, maybe there is text and numeric data mixed in the lookup column, maybe you have used the wrong 4th argument for the formula. Maybe.... -- If this helps, please click the Yes button Cheers, Shane Devenshire "John" wrote: HI I don't see your layout but your formula VLOOKUP(A2,C2:F80,2,TRUE) If range_lookup is TRUE, the values in the first column of table_array must be placed in ascending order: 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise VLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted, and will give you the exact answer. HTH John "Spock of Vulcan" <Spock of wrote in message ... VLOOKUP does not point to the correct row inconsistently. There is a response difference when naming an array versus identifying the array explicitly; there is a difference when shuffling the order of records; there is even a difference when transposing just the lookup value! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching specific record using VLOOKUP function. | Excel Worksheet Functions | |||
VLOOKUP gets wrong value | Excel Discussion (Misc queries) | |||
Vlookup - can't figure out what's wrong | Excel Worksheet Functions | |||
vlookup, what am I doing wrong? | Excel Discussion (Misc queries) | |||
What wrong with VLOOKUP formula | Excel Worksheet Functions |