Finally, one of the most anticipated changes to Excel 2021 is the brand-new XLOOKUP function. Users could already use the VLOOKUP function to find items in a table or range by row; now the XLOOKUP adds more versatility.
With XLOOKUP, the third argument has been replaced by a reference – simply point to the column in the table you want to use in the function. Consequently, any additional columns to the original table will not result in an error in your formula.
Data admin teams will also welcome the ability to return multiple cells of information with one formula. For example, you can extract 12 months of data by using XLOOKUP in just one cell.
This just scratches the surface of the changes to Excel 2021. Other new additions include:
- The ability to see any change that has been made to a spreadsheet in the last 60 days.
- Using CTRL+click to unselect cells.
- The UNIQUE formula can now return data that only appears once.
- Generate a sequence of numbers with SEQUENCE.
If you want to learn more about the capabilities of these new features in Excel, join the More4apps on-demand webinar. Over one hour, Bill “Mr Excel” Jelen will demonstrate all the new features, giving examples of how you can utilise it in your data management work. Watch the on-demand webinar here.