|
Feature
|
Excel VLOOKUP
|
MEMLOOKUP
|
AVLOOKUP family
|
|
Sort Default
|
Ascending
|
Not Sorted
|
Not Sorted
|
|
Default Match Type
|
Approx
|
Exact
|
Exact
|
|
Linear Search
|
Yes
|
Yes
|
Yes
|
|
Approx Binary Search
|
Yes
|
No
|
Yes
|
|
Exact Binary Search
|
No
|
Yes
|
Yes
|
|
Re-usable Lookup Memory (Row)
|
No
|
Yes
|
Yes
|
|
Re-usable Lookup Memory (Col)
|
No
|
Yes
|
Yes
|
|
Re-usable Lookup Memory (Cell)
|
No
|
Yes
|
Yes
|
|
Multi-Threaded
|
Yes
|
Yes
|
Yes
|
|
Horizontal Lookup
|
HLOOKUP
|
Option
|
Vertical only
|
|
Array, Expression or Range
|
Yes
|
Yes
|
Yes
|
|
Lookup Any Column
|
No
|
No
|
Yes
|
|
Use Column Labels or Numbers
|
No
|
No
|
Yes
|
|
Multiple Lookup Columns (AND)
|
No
|
No
|
Yes
|
|
Multiple Lookup Rows (OR)
|
No
|
No
|
Yes
|
|
Multiple Answer Columns
|
No
|
No
|
Yes
|
|
Return First, Last or Nth Match
|
No
|
No
|
AVLOOKUPNTH
|
|
2 Dimensional Lookup
|
INDEX(…,…))
|
INDEX(…,…)
|
Yes
|
|
Return All Matches
|
No
|
No
|
AVLOOKUPS2
|
|
No Match Error-handling
|
IFERROR()
|
IFERROR()
|
Built-in option
|
|
Compare Lists
|
V Slow
|
Faster
|
Super-Fast (COMPARE.LISTS)
|
|
Wild Card Text Match
|
Yes
|
Yes
|
Yes
|
|
Case-Sensitive Match
|
No
|
No
|
Case.AVLOOKUP2
|
|
Regular Expression Text Match
|
No
|
No
|
Rgx.AVLOOKUP2…
|
