Excel XLOOKUP and Other Lookup Functions: Upgrade Your Lookup Formulas with New Excel Functions

Price: $4.99
(as of May 21,2023 09:32:04 UTC – Details)

New Excel Functions for More Versatile and Powerful Lookup Formulas

Excel dynamic array formulas represent a significant change in the way you work with multiple return values in a formula. This book explores the latest dynamic array lookup formulas in detail, with more examples than a general-purpose Excel book ever could.

One of the most exciting new functions is XLOOKUP, which can replace VLOOKUP, HLOOKUP, and even the INDEX/MATCH/MATCH combination for simultaneous horizontal and vertical lookups. Along with XLOOKUP, you’ll learn how to use other new functions like XMATCH, FILTER, SORT, and CHOOSE.

For those still using VLOOKUP, the book covers the good old classic in depth. Downloadable Excel practice files allow for hands-on learning.

Other topics covered include using IFERROR and IFNA to handle formula errors, troubleshooting formulas, and creating drop-down lists linked to data ranges in your worksheet.

By increasing your knowledge of Excel functions, you can save time and be more efficient in building complex spreadsheets. This book is suitable for professionals and beginners alike.

Key topics that this book covers are:

How to use XLOOKUP for different types of lookup operations
How to use VLOOKUP (if needed)
Extending VLOOKUP using CHOOSE
How to use INDEX and XMATCH for simultaneous vertical and horizontal lookups
How to use FILTER to return multiple values based on a criterion
Combining SORT with FILTER to get a sorted list
Using IFERROR and IFNA to trap formula errors
How to troubleshoot and fix logical errors
How to create a drop-down list and link it to a data range

Click the “Buy Now” button on the right to learn more!

From the Publisher

Content
Autofill, Flash Fill, Freezing rows/columns, Sort and Filter, Conditional Formatting, Relative/Absolute references, Validation rules, Named ranges, IF, VLOOKUP, XLOOKUP, and DATEDIF, Excel Tables, PivotTables, Charts, Printing, and Workbook security
Remove Duplicates, Consolidate Data, Work with External Data, Troubleshoot and fix formula errors, Advanced conditional formulas, Financial functions, Macros, What-If Analysis, Pivot Tables, Pivot Charts, and Worksheet Protection
Lookup and Reference functions Like VLOOKUP, Logical Functions like IFS, Math Functions, Statistical Functions, Date And Time Functions like DATEDIF And EDATE, Text Functions like FIND, MID and TEXTJOIN, Financial Functions like PV, FV And SYD
Record and run Macros, Assign Macros to Buttons, Macro Security, Visual Basic for Applications (VBA) essentials, Variables, Program Flow, Debugging, Excel Object Model, Editing recorded Macros, User-Defined Functions, Useful Macro Examples
XLOOKUP function, VLOOKUP function, Using INDEX and XMATCH for Lookups, FILTER function, SORT function, Error handling with IFNA and IFERROR, Evaluate and Fix Formula Errors, Multiple Examples per function
Contains all the powerful content from Excel 2019 Basics, Excel 2019 Advanced Topics, and Excel 2019 Functions. Fully organized as an All-in-One tutorial and reference guide

Downloadable Practice Files
✓
✓
✓
✓
✓
✓

Reader Level
Beginning
Intermediate to Advanced
Intermediate
Intermediate to Advanced
Beginning to Advanced
Beginning to Advanced

This Book is Perfect For
Professionals, Business Owners, Students, Personal Finance
Professionals, Business Owners, Students, Personal Finance
Professionals, Business Owners, Students, Personal Finance
Professionals, Programmers, Students
Professionals, Business Owners, Students
Business and Financial Professionals, Data Analysts, Power Users, Entrepreneurs, Students

Available Formats
eBook, Paperback, and Hard Cover
eBook and Paperback
eBook and Paperback
eBook and Paperback
eBook and Paperback
eBook and Paperback

Content
Autofill, Flash Fill, Freezing rows/columns, Sort and Filter, Conditional Formatting, Relative/Absolute references, Validation rules, Named ranges, IF, VLOOKUP, XLOOKUP, and DATEDIF, Excel Tables, PivotTables, Charts, Printing, and Workbook security
Remove Duplicates, Consolidate Data, Import/Export external data, Power Query Editor, Fix formula errors, Advanced conditional formulas, Financial functions, Macros, What-If Analysis, Pivot Tables, Pivot Charts, Slicers, and Worksheet Protection
Lookup functions Like XLOOKUP and XMATCH, logical functions like IF and IFS, Math functions, Statistical functions, Date and Time functions like DATEDIF and EDATE, Text Functions like TEXTAFTER and TEXTSPLIT, Financial Functions like PV, FV And SYD

Downloadable Practice Files
✓
✓
✓

Excel Version
Excel for Microsoft 365 (as of 2023)
Excel for Microsoft 365 (as of 2023)
Excel for Microsoft 365 (as of 2023)

Reader Level
Beginner
Intermediate to Advanced
Intermediate

Ideal For
Business and Financial Professionals, Entrepreneurs, Students, Personal Finance
Business and Financial Professionals, Power Users, Entrepreneurs, Data Analysts, and Students
Business and Financial Professionals, Power Users, Entrepreneurs, Data Analysts, and Students

Available Formats
eBook, Paperback, and Hard Cover
eBook and Paperback
eBook and Paperback

Publisher ‏ : ‎ GTech Publishing (May 17, 2020)
Language ‏ : ‎ English
Paperback ‏ : ‎ 100 pages
ISBN-10 ‏ : ‎ 1916211364
ISBN-13 ‏ : ‎ 978-1916211360
Item Weight ‏ : ‎ 5.1 ounces
Dimensions ‏ : ‎ 6 x 0.23 x 9 inches