Excel XLOOKUP and Other Lookup Functions

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. XLOOKUP is a new and exciting function that replaces VLOOKUP and addresses most of the limitations of its predecessor. XLOOKUP is so versatile that it also replaces HLOOKUP 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 XLOOKUP, XMATCH, FILTER, SORT, CHOOSE, INDEX etc. VLOOKUP 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 VLOOKUP in some depth. If you're looking to skill up on VLOOKUP, 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.

1137068024
Excel XLOOKUP and Other Lookup Functions

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. XLOOKUP is a new and exciting function that replaces VLOOKUP and addresses most of the limitations of its predecessor. XLOOKUP is so versatile that it also replaces HLOOKUP 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 XLOOKUP, XMATCH, FILTER, SORT, CHOOSE, INDEX etc. VLOOKUP 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 VLOOKUP in some depth. If you're looking to skill up on VLOOKUP, 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.

10.99 In Stock
Excel XLOOKUP and Other Lookup Functions

Excel XLOOKUP and Other Lookup Functions

by Nathan George
Excel XLOOKUP and Other Lookup Functions

Excel XLOOKUP and Other Lookup Functions

by Nathan George

Paperback

$10.99 
  • SHIP THIS ITEM
    In stock. Ships in 1-2 days.
  • PICK UP IN STORE

    Your local store may have stock of this item.

Related collections and offers


Overview

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. XLOOKUP is a new and exciting function that replaces VLOOKUP and addresses most of the limitations of its predecessor. XLOOKUP is so versatile that it also replaces HLOOKUP 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 XLOOKUP, XMATCH, FILTER, SORT, CHOOSE, INDEX etc. VLOOKUP 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 VLOOKUP in some depth. If you're looking to skill up on VLOOKUP, 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.


Product Details

ISBN-13: 9781916211360
Publisher: Gtech Publishing
Publication date: 05/19/2020
Series: Excel 2019 Mastery , #5
Pages: 102
Product dimensions: 6.00(w) x 9.00(h) x 0.21(d)

Table of Contents

Introduction

Who Is This Book For?

Assumptions

Practice Files

Chapter 1: How to Enter a Formula

The Insert Function Dialog Box

Chapter 2: XLOOKUP Function

Key Features and Differences With VLOOKUP

Syntax and Arguments

XLOOKUP Examples

Vertical Lookup

Horizontal Lookup

Simultaneous Vertical and Horizontal Lookup

Return Multiple Values with Horizontal Spill

Return Multiple Values with Vertical Spill

Return Multiple Values from Non-Contiguous Ranges

Dynamic Range with XLOOKUP

Handling #N/A Errors

Find the Last Value First

XLOOKUP Left

Using Wildcards with XLOOKUP

Finding an Approximate Match

Common XLOOKUP Errors and Solutions

Chapter 3: VLOOKUP Function

Syntax and Arguments

Standard VLOOKUP Example

Finding an Approximate Match with VLOOKUP

Using VLOOKUP and the CHOOSE Function for Left Lookups

VLOOKUP and Error Handling

VLOOKUP and Wildcards

Best Practices for VLOOKUP

Common Errors and Solutions

Chapter 4: Using INDEX and XMATCH for Lookups

XMATCH Function

XMATCH Examples

INDEX Function - Array Form

INDEX Example

Using INDEX/XMATCH/XMATCH for simultaneous vertical and horizontal lookups

Chapter 5: FILTER Function

Sample Data for Examples

How to Create a Drop-down List

Simple FILTER Example

Multiple Criteria Filter using AND

Multiple Criteria Filter using OR

Sorting Filtered Data

Chapter 6: Error Handling Functions

IFERROR Function

IFNA Function

The difference between IFERROR and IFNA

Chapter 7: How to Step Through a Formula

Appendix: Shortcut Keys for Working with Data, Functions, and the Formula Bar

Glossary

Afterword

Please Leave a Review

More on Functions

Other Books by Author

From the B&N Reads Blog

Customer Reviews