However, there are two ways to achieve the goal: using a third-party add-in that mimics the function, or learning the "legacy" formula that does the exact same thing.
The add-in is not loaded or VBA macros are disabled. Fix: Go to File → Options → Trust Center → Trust Center Settings → Macro Settings → Enable all macros (restart Excel). xlookup add in download for excel 2010 free download
Excel 2010 was a revolutionary product, but it lacks dynamic array functions. Without an add-in, you are stuck with legacy functions like: However, there are two ways to achieve the