I am trying to match a Lookup Value with the largest of the potential
Responses in a second database. =vlookup(B2,data range,4,False)

I understood that VLookup will search until it finds the first match for
what is in B2 and then return the value in the 4th column of the data range.
So I sorted the data range so that the Search Column was ascending and the
4th, value column was descending. This way, the first match would return the
highest value.

For some reason though, the first match is being skipped and the data from a
duplicate (lower value) match is being grabbed.
..
..
..
Scot 5.0
Scot 4.0
..
..

The result is 4.0

here is my formula in the cell:
=VLOOKUP(B607,'[array data.xls]Orig data'!$B$1:$G$5365,4,FALSE)

B1:G5365 is sorted ascending by B and descending by column 4.

What am I missing? Thanks for your help.