D

#### Dave Peterson

If that doesn't work (since you've corrected the spelling error in one or both

of the cells), look for another Scot in the table--maybe in a hidden row (is the

table filtered?).

in the two search cells...it still bypasses the first one. Frustrating.

Thanks for the help.

Luke M said:Are there any spaces at the end of the names possibly, causing it to mess up?

When it set it up on my computer, it works okay.

--

Best Regards,

Luke M

Pogue said: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.