Once you have downloaded the appropriate file (ensure you choose the or 64-bit version that matches your specific Excel installation), follow these steps: Open Excel 2010 and click the File tab. Select Options and then click Add-Ins in the left sidebar.
This solution uses VBA code to create a UDF with identical parameter lists to the official Microsoft function. Download: You can find the file at Hermann-Baum.de . xlookup add in download for excel 2010 free download