View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default 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!