You can create your own simplified XLOOKUP in Excel 2010’s VBA editor.
No reliable, fully functional, free XLOOKUP add-in exists for Excel 2010. Users should avoid third-party downloads claiming otherwise, as they pose security risks and deliver poor performance. Instead, Excel 2010 users should master INDEX/MATCH or implement a simple, self-audited VBA UDF. For production environments requiring XLOOKUP, upgrading Excel is the only safe and effective solution. xlookup add in download for excel 2010 free download
If you see no error when typing =XLOOKUP(5,A:A,B:B) , the add-in is active. You can create your own simplified XLOOKUP in