VLOOKUP Reading Wrong Record

[Spock of Vulcan]

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!

 

[John]

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

 

[Shane Devenshire]

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....