| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using vlookup in a table that is not in ascending order
I have a table with the 1st column in ascending order but the column I wish
to find the maximum value in is not in ascending order. When I use vlookup it just returns the last number in the first column not the number that corresponds to the max number. If I could attach the spreadsheet to be more specific I would. Thanks in advance.. -- Duncan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why must the table for Vlookup be sorted in ascending order? | New Users to Excel | |||
| Digits in ascending order ? | Excel Worksheet Functions | |||
| Pivot Table Ascending Order of Row Field | Excel Discussion (Misc queries) | |||
| Order Data in Pivot Table Non ascending or Decending | Excel Discussion (Misc queries) | |||
| Is there a VLOOKUP substitute when data is not in ascending order | Excel Worksheet Functions | |||
Threaded Mode
