Once you've installed the XLOOKUP add-in, you can start using the XLOOKUP function in your Excel 2010 worksheets. The syntax for the XLOOKUP function is similar to the VLOOKUP function:
Function XLookupU(lookup_value As Variant, lookup_range As Range, return_range As Range, Optional not_found As Variant = CVErr(xlErrNA)) As Variant Dim c As Range, i As Long If lookup_range.Rows.Count <> return_range.Rows.Count And lookup_range.Columns.Count = return_range.Columns.Count Then ' handle column vs row orientation simply End If For i = 1 To lookup_range.Count If lookup_range.Cells(i).Value = lookup_value Then XLookupU = return_range.Cells(i).Value Exit Function End If Next i XLookupU = not_found End Function xlookup add in download for excel 2010 free download
: A comprehensive solution that adds XLOOKUP, FILTER, UNIQUE, and other modern functions to Excel versions 2007 through 2019. Download : Available at Hermann Baum's Excel tools . Once you've installed the XLOOKUP add-in, you can
: It is highly compatible with files from Excel 2007 to 2019 . However, VBA-based functions can sometimes be slower than native or .xll add-ins when handling massive datasets. : It is highly compatible with files from Excel 2007 to 2019