This is more flexible than VLOOKUP and works perfectly in Excel 2010 without any add-in.
To download and install the XLOOKUP add-in for Excel 2010, follow these steps:
This is a popular open-source project that provides a high-performance .xll file to add XLOOKUP and XMATCH to older Excel versions. You can find it at the Excel-DNA/XFunctions GitHub repository .
Several websites offer downloads claiming to add XLOOKUP to Excel 2010. These typically fall into three categories: