Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Why must the table for Vlookup be sorted in ascending order?
Is it true that under all circumstances I must sort the array table in
**ascending** order so that VLOOKUP will return the proper values? Is it only necessary when I deal with ranges, say minimum score and a grade? Appreciate explanation. I have a column of scores and a corresponding column of grades. e.g. 90 A 80 B 70 C 60 D I am surprised that if the table is in **descending** order and ¡§true¡¨ is used as an argument, it doesn¡¦t work even if I key in the **exact** score say 90, not 95, not 93. "D" is returned for 90. Wonder why. Thank you in advance. Epinn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
Digits in ascending order ? | Excel Worksheet Functions | |||
graph displayed in ascending order of value? | Charts and Charting in Excel | |||
Graph values in ascending order | Excel Discussion (Misc queries) | |||
pivot table in data source order | Excel Discussion (Misc queries) |