View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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?