Quote Originally Posted by p45cal View Post
It's there in msg#10, under TEST. (50 times faster than GetValues which has a performance of 1. All the macros are rated using GetValues as a base, so LookupCopy is 5230 times faster than GetValues.)
Sorry - I missed that

I'm amazed that using a Dictionary is ~100x faster than using arrays and built-in functions (e.g. TEST)

I'd have thought that building the dictionary and looking up indexes would have added more overhead