the appropriate file (usually a .xll or .xlam file) for your Excel version (32-bit or 64-bit). Open Excel 2010 and go to File > Options > Add-ins .

Manage Add-ins: At the bottom, ensure "Excel Add-ins" is selected and click Go.

: This site offers a downloadable Excel file containing VBA code for XLOOKUP, SORT, and FILTER. These are User Defined Functions (UDFs) that use the same parameters as the official Microsoft version.

You can now use =XLOOKUP(value, lookup_range, return_range) in your cells. Traditional Alternatives

This formula searches for the value 102 in the range A2:A4 and returns the corresponding value in the range C2:C4, which is "Marketing".

: Choose the .xll file that matches your Excel version (32-bit or 64-bit). In Excel, go to File > Options > Add-ins > Go... > Browse and select the downloaded file.