|
High-Performance AVLOOKUP2 family of functions
The AVLOOKUP2 and AMATCH2 functions have been re-written as multi-threaded C++ XLL functions to significantly improve performance.
The AVLOOKUP2 family can use 4 different kinds of Lookup Memory so that you can choose the optimum solution for your scenario. Lookup Memory is now stored with the workbook so that it is immediately active when you reopen a workbook.
Options are now available for all combinations of:
-Finding the Nth of multiple matches
-Case-sensitive Lookup
-Regular Expression Lookup, supporting ECMASCRIPT/PERL regular expression syntax.
Simple Replacement of VLOOKUP, HLOOKUP and MATCH
The new MEMLOOKUP and MEMMATCH provide a very simple way of speeding up exact match lookups by replacing VLOOKUP, HLOOKUP and MATCH.
MEMLOOKUP and MEMMATCH share the same Memory components as the AVLOOKUP2 family but do not have the many added features of the Advanced VLOOKUP family.
|
