View Single Post
  #9   Report Post  
Sandy Mann
 
Posts: n/a
Default

"Aladin Akyurek" wrote in message
...

LOOKUP() effects a binary search (see:
http://www.nist.gov/dads/HTML/binarySearch.html), thus very fast.


Thank you Aladin.

I don't profess to understand all the information in link that you posted
but I took from it that in the worst case scenario it would only take 17
comparisons to produce a result for 65536 rows which, as you said, is very
fast

--
Regards

Sandy

Replace@mailinator with @tiscali.co.uk