Daniel Ferry
New member
- Joined
- May 24, 2011
- Messages
- 3
- Reaction score
- 0
- Points
- 0
If you are considering using INDIRECT, then this is going to be way slower than a direct VLOOKUP.
Hey, sorry quick question:
Which is faster,
1) a Linear Search Vlookup over a range, or
2) a Binary Search Match + an Indirect reference over the range?
Context/Example:
I'm trying to test whether a date is in a list of dates. My first option is VLOOKUP(Date, Range, 0). My second option is Indirect("LISTNAME" & MATCH(Date, Range, 1)) = Date. I'm wondering which one's faster.