Several free tools can "backport" XLOOKUP into older versions:
Defaults to Exact Match: No more accidental "approximate" matches. xlookup add in download for excel 2010 free download
Once you have downloaded your preferred add-in (typically an .xll or .xlam file), follow these steps to activate it in Excel 2010: Several free tools can "backport" XLOOKUP into older
