Function XLOOKUP(lookup_value As Variant, lookup_array As Range, return_array As Range) XLOOKUP = WorksheetFunction.Index(return_array, WorksheetFunction.Match(lookup_value, lookup_array, 0)) End Function Use code with caution.
Since Microsoft does not officially support XLOOKUP for 2010, you must use a third-party add-in to enable the formula. 1. Recommended XLOOKUP Add-In Downloads xlookup add in download for excel 2010 free download
: An open-source project by Excel-DNA that provides separate 32-bit and 64-bit .xll files to add XLOOKUP and XMATCH to any Windows version of Excel. Why Use XLOOKUP
Close the editor. You can now use this simplified XLOOKUP in that specific workbook. Why Use XLOOKUP? XLOOKUP is the successor to VLOOKUP because it: Function XLOOKUP(lookup_value As Variant
Ensure the add-in is checked in the list and click . You can now use =XLOOKUP() in your spreadsheets. Alternative: Using VBA (No Download Required)
If you cannot download files due to security restrictions, you can manually add XLOOKUP functionality using a VBA script: Press to open the VBA Editor. Go to Insert > Module . Paste the following basic logic into the window: