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!