Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP with numerical sort
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| |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
How do I sort multiple columns of of numerical and alphanumerical. | New Users to Excel | |||
3 level sort, last special order | Excel Worksheet Functions | |||
Sort by column problems | Excel Worksheet Functions | |||
way to automaitic sort sheet one numerical, sheet two alpha? | Excel Worksheet Functions |