Xlookup Add In Download For Excel 2010 Free Download |top|

XLOOKUP

While Microsoft's official function is only available in Excel 2021 and Microsoft 365, you can still use it in Excel 2010 by installing a free community-developed add-in. 1. Free XLOOKUP Add-In Options

2.1 What is XLOOKUP?

Step 3: Open the Add-ins Manager

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. xlookup add in download for excel 2010 free download

If you want, I can:

combo, offering more flexibility without breaking when you move columns. lookup_array As Range

Example:

You want to find a Price (Column C) based on an ID (Column A). I can: combo