Download ((hot)) Xlookup For Excel 2016 64 Bit Official

Click , find your downloaded XFunctions64.xll file, and click OK .

However, since you are using the 64-bit version of Excel 2016, you can still use XLOOKUP by downloading a or using a VBA-based workaround . 1. Download the XLOOKUP Add-In (Recommended) download xlookup for excel 2016 64 bit

Check the box for "XFunctions" and click . You can now use =XLOOKUP() in any cell. 2. The VBA "User-Defined Function" (UDF) Method Click , find your downloaded XFunctions64