VLOOKUP & INDEX/MATCH Are Both Badly Designed Lookups: Here Are Some Better Ones
Nov19
on November 19, 2014
at 4:38 pm
Posted In: Around the Web, Downloads, INDEX, Lookups, MATCH, MVP, Performance, RegEx, Speed, VLOOKUP, Worksheet Functions
It’s fun to argue about whether VLOOKUP or INDEX/MATCH is better, but to me that’s missing the point: they are both bad. So I decided to design and build some better ones. VLOOKUP INDEX/MATCH problems Here are some of the more-frequently mentioned VLOOKYP INDEX/MATCH problems Slow exact match (linear search) Approximate sorted match is the […]