Since Excel 2010 does not support modern dynamic arrays, these add-ins replicate the core XLOOKUP syntax using older VBA or XLL frameworks.
If you must have native XLOOKUP, consider upgrading to a newer Excel version (Microsoft 365 or Excel 2021+). xlookup add in download for excel 2010 free download
If you prefer not to download external files, you can create a basic version of XLOOKUP yourself using a script: XLOOKUP function - Microsoft Support Since Excel 2010 does not support modern dynamic