I was not exactly explicit enough when I stated that I found that Index &
Match was much faster then Vlookup.

To be more precise, in a 40,000 row by 56 column WB, accessing closed WBs on
different drives (servers), a double Vlookup (error trapping) formula, with
0 as 4th argument, was replaced with a Match + Index & Match (error
trapping) formula, with 0 as the 3rd argument.

The opening time of the original WB was just under 5 minutes.
With the revised Index & Match formulas, the time was reduced to just under
3 minutes.
Recalc times went from 1½ minutes to just under a minute.

To me, that's "much" faster.<g

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


"Aladin Akyurek" wrote in message
...
RagDyeR wrote:
Actually Niek, I believe that the False (0) argument *stops* at the
*first*
exact match, while the True (1) argument causes the *entire* range to be
searched.


No. With the match-type set to TRUE (or 1), the lookup functions execute
a binary search routine, while FALSE/0 causes a lineair search.

Did you actually find False to be slower then True?


Yes, absolutely.

Also, from personal experience, Index & Match are *much* faster then
Vlookup.

=INDEX(ReturnRange,MATCH(LookupValue,MatchRange,1) )

and

=VLOOKUP(LookupValue,Table,Idx,1)

=LOOKUP(LookupValue,MatchRange,ReturnRange)

won't differ "much" in performance.