I have a column of names with 5 rows of scores. When I sort by the
names and use the VLOOKUP to get the scores the functions works as
expected. When I sort for the column that has the highest score (found
using the MAX function) the names are not in alphabetical order. The
VLOOKUP function stops working when it gets to name that are out of
aphetically order.

Will Work
SORT
Bob | 23026|24512|12489|26541|
Don |50647 |21489|54735|24864|

Will Not Work SORT
Don |50647 |21489|54735|99999|
Bob | 23026|24512|12489|26541|