View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Knox Knox is offline
external usenet poster
 
Posts: 45
Default limits on lookup function?

I have found that the lookup function does not work if it is sifting through
lots of records. Also it seems to work better if the data is sorted. Is
there any limit on the number of records for the lookup function? Does
sorting the data help? What exactly are the limits to the lookup function?
thank you!