sort data for vlookup
 

Do I need to sort data for vlookup porpose?

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?

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?