XLOOKUP is most often used as an alternative to the popular VLOOKUP function to look up a value vertically in a column in a data set. Recommended article: How to Lock Cells in Excel (Protect Formulas and Data)ĭo you want to learn more about Excel? Check out our virtual classroom or in-person Excel courses > Issues and limitations of VLOOKUP
One of the primary benefits of XLOOKUP is that it can look up from columns to the left in a data set and return a range. It allows you to look up a value from an array in a range or table and return one or more results. It has a new set of arguments and is available in Excel 2021 and 365. The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function (as well as HLOOKUP and INDEX / MATCH functions).
By Avantix Learning Team | Updated March 9, 2023Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019, 2021 and 365 (Windows)
0 kommentar(er)
