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?
|