Another excellent option is the add-in from Gyankosh.net . This is a utility created to act as a direct replacement for XLOOKUP, making it available to all Excel versions. It's designed to be simple: you download it, install it as an add-in, and can then start using it as a custom function in your spreadsheets.
The add-in is unsigned. Open Excel as admin, go to File → Options → Trust Center → Add-ins → Uncheck “Require add-ins to be signed by Trusted Publisher”. xlookup add in download for excel 2010 free download
Click the tab in the top-left corner and select Options . Another excellent option is the add-in from Gyankosh
How to Use XLOOKUP in Excel 2010: Free Add-In Download and Alternatives The add-in is unsigned
Press on your keyboard to open the Visual Basic for Applications (VBA) Editor. In the top menu, click Insert > Module .