© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. MurrayAdvanced Excel Formulashttps://doi.org/10.1007/978-1-4842-7125-4_12

12. XLOOKUP: The New Kid on the Block

Alan Murray1  
(1)
IPSWICH, UK
 

The XLOOKUP function was released in 2020 to provide a superior lookup function to others that have existed in Excel for years.

This function is the new kid on the block of lookup functions. It gains more fans every week as Excel users discover XLOOKUP and the simplicity it provides in looking up and returning values.

This function is only available for users of Excel 2021 (Windows and Mac), Excel for Microsoft 365 (Windows and Mac), and Excel for the Web. It is a fine representation of how we work in modern Excel. ...

Get Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial