Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort data for vlookup
Do I need to sort data for vlookup porpose?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort data for vlookup
You only *need* to sort your data if you want an approximate match if an
exact match isn't found. If you only expect to use data with exact matches then you do not need to sort. However, sorting makes the function work faster. Biff "Holly" wrote in message ... Do I need to sort data for vlookup porpose? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort data for vlookup
And I'm sure Biff also meant to add,
With an unsorted data set though, you do need to also set the 4th parameter in Vlookup to 0 or FALSE. =VLOOKUP(your_value,your_range,your_offset,0) -- Regards Roger Govier "T. Valko" wrote in message ... You only *need* to sort your data if you want an approximate match if an exact match isn't found. If you only expect to use data with exact matches then you do not need to sort. However, sorting makes the function work faster. Biff "Holly" wrote in message ... Do I need to sort data for vlookup porpose? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP with numerical sort | Excel Worksheet Functions | |||
Sort of VLOOKUP | Excel Worksheet Functions | |||
Vlookup, Sort ?? | Excel Discussion (Misc queries) | |||
data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) |