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.