The XLOOKUP function is one of the most powerful tools ever added to Excel, but Microsoft officially only supports it in Microsoft 365 and Excel 2021. If you are still running Excel 2010, you likely see the #NAME? error when trying to use it. Fortunately, you can bridge this decade-wide gap using free third-party add-ins. Why Excel 2010 Needs XLOOKUP
If you prefer not to use add-ins for compatibility reasons (e.g., sharing the file with others who don't have the add-in), you must use these built-in alternatives:
Download link (copy and paste into your browser):
github.com/excel-legacy/XLOOKUP-AddIn/releases
1. INDEX + MATCH (Native, No Add-in Required)
=INDEX(return_range, MATCH(lookup_value, lookup_range, 0))
Recommended concise path
- Try INDEX/MATCH for immediate needs.
- If you need exact XLOOKUP behavior often, add a simple VBA UDF (paste above) and save as .xlsm.
- Consider upgrading Excel for full native support.
