Vlookup algorithm

  • Thread starter Thread starter ampm
  • Start date Start date
A

ampm

Hi,

Who know the internal algorithm of the Vlookup function?
especially, I mean the not accurate mode (4th argument = 1).

Where can I find reference for it ?

Thank
 
Hi
I doubt Microsoft has ever published this algorithmn. So probably no
chance to get it. You may have a look at Gnumeric and see if you found
this kind of algorithmn in their coding :-)
 
It works like a Binary Search algorithm.
Google for Binary Search will show you lots of information.

Charles
______________________
Decision Models
The Excel Calculation Site.
www.DecisionModels.com
 
Back
Top