XLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
XLOOKUP isn’t available as an official Microsoft add-in for Excel 2010. It’s a built-in function in newer Excel (Microsoft 365 / Excel 2019+). For Excel 2010 you can either use alternatives or third‑party workarounds. xlookup add in download for excel 2010 free download
: Highly compatible with the official syntax; includes separate 32-bit and 64-bit versions to match your Excel installation. Download from GitHub Releases Hermann Baum's XLOOKUP UDF : Highly compatible with the official syntax; includes
Find the grade for a score of 85 (lookup array: 0,60,70,80,90 → return array: F,D,C,B,A) error when trying to use it
To find the department of an employee with ID 102, you can use the following formula:
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