Testing of multiple such add-ins (sourced from third-party forums) reveals:
Conclusion: There is no trustworthy, fully functional, free XLOOKUP add-in for Excel 2010.
If you are looking for a Microsoft-released add-in that gives Excel 2010 the XLOOKUP function, it does not exist. xlookup add in download for excel 2010 free download
XLOOKUP is a native function introduced in Excel 2021 and Excel 365. It relies on modern calculation engines that are not present in Excel 2010. Microsoft does not backport new functions to older versions via add-ins.
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. Testing of multiple such add-ins (sourced from third-party
You should never download Excel add-ins from random pop-up ads or unverified YouTube links. Below are two trusted sources for the free XLOOKUP add-in.
XLOOKUP is a modern lookup function introduced by Microsoft in Excel 2021 and Microsoft 365. It is not natively available in Excel 2010. There is no official, free add-in from Microsoft that adds true XLOOKUP functionality to Excel 2010. Any third-party add-in claiming to add XLOOKUP to Excel 2010 is either a custom VBA-based simulation (with limitations) or potentially unsafe. Users seeking similar functionality in Excel 2010 must rely on alternative native functions or third-party UDFs (User Defined Functions). Conclusion: There is no trustworthy, fully functional, free
If you have Excel 2010 but have a Microsoft account (used for email), you actually have access to modern Excel for free.
The web version of Excel is free and includes XLOOKUP. You can create your spreadsheet there, use the modern formulas, and download the file. While the formulas won't calculate in your Excel 2010 desktop app if you open it later, the data will remain saved.
=SUMPRODUCT((A2:A1000=E2)*B2:B1000)
Once you have downloaded the .xlam file, follow this guide exactly.