Microsoft does not provide a native function for Excel 2010; it is exclusive to Microsoft 365 Excel 2021
XFunctions (GitHub): 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. xlookup add in download for excel 2010 free download
Q: Is it legal to download a free XLOOKUP add-in for Excel 2010?
A: Yes. Microsoft does not prohibit third-party VBA functions. The add-in does not modify Excel’s source code. Microsoft does not provide a native function for
lookup_value is the value you want to search fortable_array is the range of cells that contains the datacol_index_num is the column number that contains the value you want to return[if_not_found] is the value to return if the lookup value is not found[match_mode] is the match mode (exact or approximate)[search_mode] is the search mode (vertical or horizontal)But fear not! In this article, we'll explore the world of XLOOKUP add-ins and provide a step-by-step guide on how to download and install the XLOOKUP add-in for Excel 2010, completely free of charge. By the end of this article, you'll be equipped with the knowledge to harness the power of XLOOKUP in your Excel 2010 workflow. lookup_value is the value you want to search