Do I need to sort data for vlookup porpose?
T T. Valko May 4, 2007 #2 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
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
R Roger Govier May 4, 2007 #3 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)
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)
