Excel XLOOKUP and Other Lookup Functions by Nathan George

Excel XLOOKUP and Other Lookup Functions by Nathan George

Leverage New Powerful Lookup Functions in Excel 2019

Dynamic array formulas represent one of the biggest changes to Excel formulas in years. Maybe the biggest change ever. They enable you to work with multiple return values at the same time in a formula. XLOKUP is a new and exciting function that replaces VLOKUP and addresses most of the limitations of its predecessor. XLOKUP is so versatile that it also replaces HLOKUP and the INDEX/MATCH/MATCH combination used for simultaneous vertical and horizontal lookups.

A Detailed Walkthrough of New and Exciting Lookup Functions Recently Released

This book provides comprehensive coverage of several of the newly released dynamic array lookup formulas in more depth, and with more examples, than would have been practical in a general-purpose Excel book. Learn how to use functions like XLOKUP, XMATCH, FILTER, SORT, CHOSE, INDEX etc. VLOKUP will still be in use for a while as the new dynamic array functions are not available to one-time purchase version of Office users yet. For that reason, this book also covers the good old VLOKUP in some depth. If you're looking to skill up on VLOKUP, then this book is also for you. Functions can save you a lot of time as they're tried and tested predefined formulas.

From simple calculations to building complex spreadsheets that require multiple formulas, knowing the right function to use can increase the accuracy and efficiency of your work.

Included are downloadable Excel practice files to enable you to follow the examples in the book hands-on.

George, Nathan: - Nathan George is a computer science graduate with several years' experience in the IT services industry in different roles which included Excel VBA programming, Excel training, and providing end-user support to Excel power users. One of his main interests is using computers to automate tasks and increase productivity. As an author, he has written several technical and non-technical books.

SKU	Unavailable
ISBN 13	9781916211360
ISBN 10	1916211364
Title	Excel XLOOKUP and Other Lookup Functions
Author	Nathan George
Series	Excel 2019 Mastery
Condition	Unavailable
Binding Type	Paperback
Publisher	Gtech Publishing
Year published	2020-05-19
Number of pages	102
Cover note	Book picture is for illustrative purposes only, actual binding, cover or edition may vary.